thanks for all the replies. but I was able to use the column as an nvarchar instead of needing to convert to int.

However, I did try:

select ColInt =

case

when isnumeric(fieldvarchar)...

I am having a similar problem. The case and convert methods are not working for converting an nvarchar to int column...I have tried many methods but below are some examples...