At least in Postgresql you can do something like: SELECT * FROM table where item_code ILIKE 'blabla';
But I guess it's standard, so you can use it in any DB.
Larry Sandwick wrote:
Is there a way to run a query so that it ignores the case, and the query is not case sensitive?
The data being stored is "m1234"
Query
Select item number from item where item_code = "M1234" ;
The query above should return the data above.
TIA
Larry Sandwick
Sarreid, Ltd.
Network/System Administrator
phone: (252) 291-1414 x223
fax : (252) 237-1592
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
