Please forgive if this is the wrong

[loriek]

Please forgive if this is the wrong forum. I've got a query that utilizes [enter something here] to prompt the user for a value.

What I'd like to do is look for a like clause instead of =. For example, Select * from mytable where name like [enter something here].

The problem is my users have to add * before the text and after *Joe* in order to find Joe Smith, Joe Waltz, etc.

How can I handle placing the two * before and after the input?

Thanks... I know one of you will know....

 

[Remou]

How about:

[tt]Select * from mytable where name like "*" & [enter something here] & "*"[/tt]

 

[loriek]

AWESOME/. I'll give it a try.