Re: [GENERAL] Case insensitive LIKE queries

2000-11-01 Thread Oliver_Hall
like 'TEST'; Upper will change the fields to upper case for testing purposes. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Yann Ramin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 01, 2000 12

Re: [GENERAL] Case insensitive LIKE queries

2000-11-01 Thread Adam Lang
L PROTECTED]> Sent: Wednesday, November 01, 2000 12:05 AM Subject: [GENERAL] Case insensitive LIKE queries > Hello, > > What would be the most effective way of preforming a case-insensitive LIKE > query? I've notived that MySQL somehow ALWAYS does it case insensitive, > which is

[GENERAL] Case insensitive LIKE queries

2000-10-31 Thread Yann Ramin
Hello, What would be the most effective way of preforming a case-insensitive LIKE query? I've notived that MySQL somehow ALWAYS does it case insensitive, which is not very smart, but I should expect this feature to exist without reasonable pain on the programmer;s end? Yann -- ---