Re: SQL-Problem - UPPER()

2001-01-24 Thread Joseph Youngquist
ot; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 24, 2001 12:54 PM Subject: SQL-Problem - UPPER() > Hello List, > > if a problem with this sql-stement (i use DBI and the CSV-Modul) : > > $sql = "SELECT * FROM gbook

SQL-Problem - UPPER()

2001-01-24 Thread Gamperl Johannes
Hello List, if a problem with this sql-stement (i use DBI and the CSV-Modul) : $sql = "SELECT * FROM gbook WHERE notes LIKE '%$in{'searchValue'}%' OR keywords LIKE '%$in{'searchValue'}%'"; i would have a case sensive search, so when i use the UPPER() command i get an error: Parse er