compare string to a number in sql

Hi,

I have a table with a string field that can store numeric field. How do I
make a query to compare this field with a numeric value.
Example:
Select * from table1 where field1="condition" and field2>1000
Do I have to convert field2 to numeric at sql? If so what function do i
have
to use?

Thanks,

Carla

-- 
Message posted via http://www.accessmonster.com