RE: [PHP-DB] Non case-sensitive SQL Query

Is DB2 by default case sensitive on queries ? You could do an like 'Anders%' or like 'anders%' -----Original Message----- From: Anders Dannberg [mailto:anders.dannberg@edk.se] Sent: Friday, August 18, 2000 12:44 To: php-db@lists.php.net Subject: [PHP-DB] Non case-sensitive SQL Query Hi all! I need some help on how to make a NON case-sensitive sql query. I use the following query which outputs what i need: $query = "SELECT * FROM user INNER JOIN maintable ON user.number = maintable.number WHERE name LIKE 'Anders%'"; However, as this is case-sensitive, it will not display, for example records containing "anders", but only "Anders" etc. Is there a way i can make sql-queries NON case-sensitive (without changing the already inputted data in the DB) Is there a way i can do this in within the code? Without any changes to database settings... I'm using DB2, PHP4. Thanks in advance. Anders -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net