Hi,
I'm displaying a textbox to allow the user to search my Interbase database 
by entering 1 or more characters and returning all records that match 
(supposedly!).

I have a few customers whose names begin with 'Michael'. However if I 
enter 'mich' or 'MICH' in the textbox, it doesn't return any records - I 
have to enter 'Mich' exactly as it appears in the database. 

Can anyone tell me how to convert my search to upper or lower case? I've 
tried things like 

oCMD = New OdbcCommand("SELECT * FROM CUSTOMER WHERE LOWER(CUSTOMER_NAME) 
LIKE LOWER('" & txtCustName.Text & "%') ORDER BY CUSTOMER_NAME", oConn)

but these give me error messages (I'm creating an asp.net page - maybe I'm 
posting to the wrong list here??)

Thanks for any help.
Jennie.