Home Forums SQL Server 2005 Development How to get a row number which is failing during conversion RE: How to get a row number which is failing during conversion

  • January 23, 2009 at 9:38 am

    #931898

    There will probably be a row that has a character that cannot be converted to integer.

    try using this code to find the offending row(s)

    SELECT * FROM YourTable

    WHERE ISNUMERIC(YourColumn)=0