Like Query

[ptrifile]

I have a simple query that lets a user query on a persons name but only put in a partial name.....i use the following:

Like ([enter partial name] & "*")

This works fine however this method you have to make sure you put in the first part of their name, so if there name is Steven Person, you have to at least put in "STE" I would like to modify it so that even if the user puts in "even" it would bring it up. Any suggestions on how to change the query to do that?

Any help is appreciated!

Thanks!

Paul

 

[PHV]

Like "*" & [enter partial name] & "*"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886