Welcome to the world of .NET
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment