Home Forums SQL Server 2008 T-SQL (SS2K8) How to sum in SQL removing varchar RE: How to sum in SQL removing varchar
Igor Micev
SSC-Dedicated
Points: 33109
More actions
May 3, 2013 at 3:15 am
#1612110
Hi
SELECT sum(CONVERT(float, ft.amount))
FROM filetransaction ft
WHERE ft.fileid <>332 and ISNUMERIC(ft.amount)=1
Check this also http://www.sqlservercentral.com/articles/IsNumeric/71512/
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com