Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-06 : 08:56:19
M.Rosalin writes "HOw can i use Format() fuction for formatting decimal point value in SQL Server?"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-06 : 10:53:07
In ASP you use FormatNumber
In VB you use Format
In SQL, you use Round(value, 2)


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -