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 2:28 pm

    #1625649

    >>where column1 = 1

    This throws the error Conversion failed when converting the varchar value '-4.67625' to data type int.

    >>where IsNumeric(Column1) = 0

    This will exclude one row. This is the row I intend to catch in my CASE statement where Column1 is null.

    where IsNumeric(Column1) = 0 shows one row, again the statement I intend to includ in my case statement.

    Thanks