Generally in DBs, data is case sensitive.
Simply you can do an uppercase or lowercase conversion in both sides.
Ex : Select item number from item where upper(item_code) = upper("m1234");
-ramki
----- Original Message -----
From: "Larry Sandwick" <lgs@xxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Tuesday, November 18, 2003 1:23 AM
Subject: Query Case In-sensitive
> 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
