sql mid (). Is it possible?!

dejanc

Registered User.
Local time
Yesterday, 23:27
Joined
Aug 4, 2009
Messages
45
Hello,

I have a question. I need to pull out records, but some records have different nr. of characters or they are write oposite. And I need get them in the same group.
I will write down examples...

record:
iron-EKO
ironEKO
EKOiron

How can I get all 3 records in the same query by word EKO?

Please help someone, and thanks in advance....!!!
 
thanks for quick reply

I will try
 
Have another question. With LIKE operator I got it what I want. But, I want to filter query from form with Listbox. I know how to do that, but in this case I dont know where to put FORMS!FORM1!LISTBOX
Please see print screen from access..
 

Attachments

Have a search for "search form" this will show you how to implement this succesfully.
 

Users who are viewing this thread

Back
Top Bottom