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"


Select item number from item where item_code = "M1234" ;

The query above should return the data above.


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

Reply via email to