Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

SELECT CONVERT(VarChar(50), @Num, 0)

3> 4> DECLARE @Num Money 5> SET @Num = 1234.56 6> SELECT CONVERT(VarChar(50), @Num, 0) 7> GO -------------------------------------------------- 1234.56 (1 rows affected) 1>