Convert nvarchar to int in SQL
Posted on 2008-06-11
I would like to convert "005000000000" currently in varchar(12) into just show "5000000000", tried to convert into int but has the following error
"Msg 248, Level 16, State 1, Line 1
The conversion of the varchar value '005000000000' overflowed an int column. Maximum integer value exceeded."
Reason not using substring function is the value will always change so substring wont work =\
Please kindly assist