Case-sensitivity - SQL Query

[wxdqz]

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)

I'm using DB2, PHP4.

Thanks in advance.
Anders