search/select case-insensitivly.

["Zhidian Du" <duzhidian@xxxxxxxxxxx>]

I want a PHP program to search case-insensitivly.

for example:
select Name from mytable where Name = '$Name';


Here $Name is what users' input maybe JOHN, john.  How to let it match John 
in table and find that record?


Thanks.

Zhidian Du





_________________________________________________________________
Surf the Web without missing calls! Get MSN Broadband. 
http://resourcecenter.msn.com/access/plans/freeactivation.asp