Case Upper / Lower

[Mish_h]

Hi

I have a form that searches for a match to what is put in a text box.

I have something along the lines of this as the main sql statement

Select * from Qry_Filter where
"[USERNAME] LIKE """ & txt_UserName & "*"""


It works fine however it is case sensitive so if i input something all lower case it will not return a value because for example it has a capital letter to start in the db table.

How can i get round this ?

Thanks

 

[GumbyD]

what if you did something like this:

txt_UserName = UCase(txt_UserName)

Select * from Qry_Filter where
"UCase([USERNAME]) LIKE """ & txt_UserName & "*"""

It is odd because I have not seen case cause criteria to not work before, but if it try the above.

 

[Mish_h]

Thanks i will try that.
It's case sensitive because i am building a front end in access that links to a table in oracle