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: [EMAIL PROTECTED] http://usphdba.gsk.com/ - USPHARMA Database Site "Ron Piggott" <[EMAIL PROTECTED]> 06-Oct-2005 03:02 Please respond to "Ron Piggott" <[EMAIL PROTECTED]> To "PHP DB" <php-db@lists.php.net> cc Subject [PHP-DB] 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