Substitute for format function

[kaur_gurpreet]

I've a Field with following data

12
12.4
23.44
4.5

if I run a query

SELECT format(field,'#0.00') from table1

it gives the following output in Ms-Access

12.00
12.40
23.44
4.50


HOW DO I DO THE SAME FOR SQL SERVER 7.0

[PinkPanther2003]

Hi Kaur,

--Put this in Query Analyser and hit F5
SELECT cast(12 as decimal(10,2))
SELECT cast(12.4 as decimal(10,2))
SELECT cast(23.44 as decimal(10,2))
SELECT cast(4.5 as decimal(10,2))

I would also suggest buying a good reference book on SQL Server.

I've got 'SQL Server 7 Database Design' by Kevin Hough. I used it to prepare for my MCP but I still use it all the time as a reference.

I am sure others can recommend other books to.

HTH,

Peter

[kaur_gurpreet]

hi

thanks for the help.
can you guide me for mcp as well

[kaur_gurpreet]

Stuck with another problem
How to get numbers formatted with comma
in ms-access i use
select format(123344,"##,##,##.00")

how to do in sql server