[snip] Tried that but no luck. What I want is a search that will look for '150000' (for example) in the field BOOKING.
So if I enter '1' in my search field, it will find all instances of BOOKING with a '1' in it. Conversely, if I enter '12345' in my search field, it will find all instances of BOOKING with a '12345' in it. [/snip] SELECT * FROM WhInventory WHERE Booking LIKE '%150000%' ORDER BY Booking Should work. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
