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