Depends on database ... in Oracle yes data is stored in mixed case so you can use functions like UPPER & LOWER to force case. Roy A. Jones US Pharma Database Administration GlaxoSmithKline Inc. US Pharma IT, Shared Services Email: roy.a.jones@xxxxxxx http://usphdba.gsk.com/ - USPHARMA Database Site "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx> 06-Oct-2005 03:02 Please respond to "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx> To "PHP DB" <php-db@xxxxxxxxxxxxx> cc Subject is SELECT case sensitive Is SELECT typically case sensitive? Is there a way to make it case sensitive? (In the example below can $searching_criteria become case sensitive?) SELECT * FROM table_name WHERE column LIKE '$searching_criteria'; Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
