Samples

DECLARE @val money

SET @val = 1234567.89

SELECT CONVERT(char(15),@val,1)





DECLARE @val int

SET @val = 1234567

SELECT LEFT(CONVERT(char(18),CAST(@val AS money),1),15)





DECLARE @val decimal(9,2)

SET @val = 1234567.89

SELECT CONVERT(char(15),CAST(@val AS money),1)





DECLARE @val real

SET @val = 123456.78

SELECT CONVERT(char(15),CAST(@val AS money),1)

 

Edited by - davidburrows on 06/26/2003 07:25:17 AM