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
Far away is close at hand in the images of elsewhere.
Anon.