Search results

I am not using MySQL I am using Access 2007 :)

If I search for "*Test*" then I won't get test or TEST, and the same with "TEST" I wil only get records that include TEST. My co-worker does not have the issue so I thought that must be a setting issue.

I probably should make clear that the syntax was only wrong here in my issue description.it is correct in my real query,so I still have the problem!:( I have this issue also using the filter option "contain"

Sorry yes of course it is "*test*". Was accidentally using MySQL syntax.

First of all - thank you so much for the fast reply!! :) Ok let me give you an example, if I for example say : Select * from test where testcolumn like "%test%" I get only data back that include "test" but I wouldn't get any records back that include "Test" or "TEST". What can I do that I get...

Hi there, I am new here and I hope I won't break any rules already with posting this one. :) My Access 2007 is case sensitive and I would like to know how I can change this, I have a lot of data that are the same but sometimes capitalized and sometime not and it would make my life so much...