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.
SwePeso
SSC-Dedicated
Points: 39752
More actions
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"