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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
