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

  • Steve, cause it's an overflow I recon it's not that there is char

    Also be careful because

    This will return a 1 for ISNUMERIC but it's not convertible: '10,0'.

    What I normally do is run a top until I find a subset of data that contains my bad value and then I go from there.

    What data type are you converting to?

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life