convert nvarchar to number

[scorpion99]

Hi all,

I have a table in access linked to SQL.I am doing a query where I am using a field named comment from this table.
The field is designed in SQL as nvarchar(255) . I am writing integers numbers in this field. What I want to do in my query is to convert this field from nvarchar to int so I can use the SUM function.Can anyone help?

[June7]

Did you try the Int() function?

[sharondavis]

yup, as i have learned, int() will work.. you should try.
free bonus casino

[qa12dx]

look up sql ALTER TABLE

works if your col you want to change is empty

else u'd have to add a col, update it from the char col and then remove the char col

you can't do this from access though..

[ranman256]

I believe the correct function is CInt()

[June7]

Both work. CInt() will round decimal portion. Int() just drops the decimal portion.

Both will error if the value contains alpha or empty string. CInt() also errors on Null.

[scorpion99]

Thanks , it solved the issue