you can convert both of the sides to one case, similar to this:
select item_number from item where upper (item_code) = upper ("M1234");
this way you ensure that both the value in the database and the selection
variable are in one and the same case: capital. this should work in just
about every single database, there's always a function to convert a string
to upper case, the syntax might be different to the above example (which
is mysql). just consult your dbms documentation.
ciao,
andrei
.
"Larry Sandwick" <lgs@xxxxxxxxxxx>
2003/11/17 09:53 PM
Please respond to
<lgs@xxxxxxxxxxx>
To
<php-db@xxxxxxxxxxxxx>
cc
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
