Still having a problem. At about record 14334, I get the error message:
SQL Execution Error
Executed SQL Statement
SELECT CASE IsNumeric(AdNumber)
WHEN 1 THEN CAST(AdNumber AS Int)
ELSE 0
END AS AdNumber FROM TNDL
Error Source .NET SQLClient Data Provider
Error Message; SyntaxError converting the varChar
Value '. ' to a column of the data type int
Could it be that a period passes the IsNumeric test, but fails when it actually is converted to integer?
How could I handle this?
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296