al4629740
asked on
convert string to integer
I have a column that is nvarchar(50) called Number1. How do I convert the string to a number?
select * from table where Number1 > 0
select * from table where Number1 > 0
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the split. Good luck with your project. -Jim