Thursday, June 4, 2009

Comma seperated decimal column

Using the below way we can conver the decimal to be shown as comma seperated string

DECLARE @Test DECIMAL(20,4)

SET @Test = 123123123.123155

SELECT convert(nvarchar, cast(@Test as money),1)

No comments: