Case sensitive query

[Matt Brown]

Hi,

I am using the following in a query to filter out records from a csv linked file:

Like '*' & [Forms]![frmIfrComponentsMainScreen]![SearchByComponent] & '*'

This works just fine to a point, it seems to be case sensitive, how can i make it not case sensistive?

I am sure i have overcome this before but can't remember how i did it.

Thanks

Matt

 

[namliam]

try using uppercase or lowercase

 

[dcx693]

That's strange, as normally Access is not case-sensitive when performing operations in queries.

Along the lines of namliam's suggestion, use the UCase or LCase function to make everything upper or lowercase.

 

[Matt Brown]

Hi Guys,

Thanks for the tips.

dcx693 you are right about not normally case sensistive as i have many other queries where this does not become a problem.

The only thing that i can think of is the data is linked to a csv file, this is the only thing different to all of my other queries. (100's of them).

Perhaps there is an issue with csv data as it is not a true Access table.

oh well will try your suggestions anyway,

cheers

Matt