Home Forums SQL Server 2005 T-SQL (SS2K5) ltrim rtrim Causing Floating Field to Round up?? RE: ltrim rtrim Causing Floating Field to Round up??
david.ostrander
SSCommitted
Points: 1828
More actions
October 22, 2013 at 1:51 pm
#1660687
Thank you for the fast response. You stated
To avoid this problem, you should do an explicit conversion.
My column is Revenue (float, null)
Revenue (float, null)
How would I do the explicit conversion? On the view or select statment?
Regards,