sql mid (). Is it possible?!

[dejanc]

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....!!!

 

[boblarson]

Use

Like '*EKO*'

as the criteria

 

[dejanc]

thanks for quick reply

I will try

 

[dejanc]

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..

 

[namliam]

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