there is a varchar column named emp_ref_no and it's length 20, I tried to convert it into int
select cast(emp_ref_no as int)
from tables
where isnumeric( emp_ref_no ) =1
however I got error message:
The conversion of the varchar value '133261280299' overflowed an int column. Maximum integer value exceeded.
Is anyone can help? many thanks
select cast(emp_ref_no as int)
from tables
where isnumeric( emp_ref_no ) =1
however I got error message:
The conversion of the varchar value '133261280299' overflowed an int column. Maximum integer value exceeded.
Is anyone can help? many thanks
Comment