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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.