Home Forums SQL Server 7,2000 T-SQL Error converting data type varchar to numeric RE: Error converting data type varchar to numeric

  • It depends on the data stored in the table. Try running this:

    SELECT Original_Dollar_Amt , Serial_No FROM Properties where ISNUMERIC(Original_Dollar_Amt) = 0 OR ISNUMERIC(Serial_No) = 0

    Does it return rows? If so, fix the values and there you are.

    Hope this helps

    Gianluca

    -- Gianluca Sartori