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
Select on type varchar is not case sensitive, you can make it case
sensitive with the BINARY option:
SELECT * FROM table_name WHERE BINARY column LIKE '$searching_criteria';
Koen
On 06/10/05, Ron Piggott <[EMAIL PROTECTED]> wrote:
> Is SELECT typically case sensitive? Is there a way to ma
