Jasper IT Services
Thursday, July 16, 2009
SQL Server error converting nvarchar to float
Had numbers in my column like "1,298.05" when I was expecting 1298.05 So to get around this, whenever I refer to the column for calculations I use:
convert(money,REPLACE(t1.[TOTAL_AMOUNT_PAID],'"', ''))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment