Home Forums SQL Server 2008 T-SQL (SS2K8) How to sum in SQL removing varchar RE: How to sum in SQL removing varchar

  • 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