Home Forums SQL Server 2005 T-SQL (SS2K5) Arithmetic overflow error converting varchar to data type numeric. RE: Arithmetic overflow error converting varchar to data type numeric.

  • September 4, 2010 at 10:10 am

    #1216537

    What does this query return?

    SELECT MAX(LEN(PARSENAME('0.' + Col1, 1))) AS Part1,

    MAX(LEN(PARSENAME('0.' + Col1, 2))) AS Part2

    FROM Table1

    WHERE Type = 'ABC'

    N 56°04'39.16"
    E 12°55'05.25"