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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 1:23 AM
Subject: [PHP-DB] 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

Reply via email to