Home Forums SQL Server 2005 T-SQL (SS2K5) Error converting data type varchar to numeric in CASE statement RE: Error converting data type varchar to numeric in CASE statement

  • June 19, 2013 at 11:33 am

    #1625585

    This works

    SELECT

    CONVERT(decimal(20,6),Column2)

    FROM ....

    WHERE column1 <> 'abc'