I have a Tel field defined as Char(12). If I do this command:
SELECT Tel,CAST(Tel AS Numeric) FROM Site
I get:
"Error converting data type varchar to numeric."
Basically, I have a telephone field that I want to take its data and replace that into a Numeric(15) field which already exists. All telephone numbers have a 506-111-2222 format. The example above is just a short SQL command I was trying to execute as using Str() and concatening the 1-3, 5-7 and 9-12 characters into a numeric value did not do.