Re: making varchar field to act like numeric field

[Chris W]

Rajesh Mehrotra wrote:
> Hi Steve,
>
> Correction:
>
> Use: "select * from table where field1 like '4%' or like '5%' or like
> '6%' or field1 like '7%';" 
>   

This would not have the desired result as it would return things like 
500 or 50 or 5,000,000 etc.  You must use the cast as another reply 
suggested.  However I'm unclear as to why you would store numeric data 
in a var char field.  If at all possible it would be better to store it 
in a numeric field.

-- 
Chris W
KE5GIX

Gift Giving Made Easy
Get the gifts you want & 
give the gifts they want
One stop wish list for any gift, 
from anywhere, for any occasion!
http://thewishzone.com