substitute of Format(myColumn,"0.00") function

Hot Topic

Dynamic SQL task
Setting Default ISOLATION LEVEL
Creating new connection manager types
SSIS will not start after SQL Server 2005 SP1 upgrade
SQL Server 2005 SP1 installs successfully but Microsoft update still showing it as needed?
Stupid Replication Q
Date between 1/1/0001 to 31/12/9999 possible in Sql server
sql2005:Cannot use SAVE TRANSACTION within a distributed transaction
How to run "Execute Package" Task Conditionally in SSIS?
Restoring just a table from a full backup

SQL Server

What SqlDbType should I use for nvarchar(MAX), varbinary(MAX), etc?
SqlDriverConnect SqlServer Memory leak
Number of charts vary with respect to a parameter
How automatically process a Cube periodically
ReportViewer control
Source table filter
Large text Insert
Display Row Data As Cols
Moving from 2000 to 2005: issue Accessing cursor returned by sp
AdventureWorks Sample Reports

substitute of Format(myColumn,"0.00") function

hi,

the query ----> select format(Total,"0.00") from mytable works very well in MS Access 2000/97 but the same query dosen't work in MS SQL Server 2000.

i need the substitute for this query. please help me it's very urgent

thanks a lot for consideration

Vikas

Answer this question

substitute of Format(myColumn,"0.00") function

swo
Please take a look at STR function.
substitute of Format(myColumn,"0.00") function

Answer this question