Wildcard/Shorten for queries (1 Viewer)

Hi guys, what I'm trying to achieve is to have some form of wildcard inputted into my queries.

I have a database which is for a nurse to input patients etc...
One of my queries is to retrieve every patient who has been in for a headache or stomach ache etc..

Is there a way i can shorten what the user has to input.

For example instead of them typing "headache" or "stomach ache" into the prompt box they just type in "head" or "stom" etc...

Is there a way I can do this for all queries and make it a standard, instead of having to manually set the wildcards for each results there may be.

Thanks in advance.

Matt

Using wildcards/using LIKE operator will affect your efficiency of your Query. However, to answer your question yes, you can use wildcard. How are you obtaining the User input, if it is a prompt box, just use.

Thank you ever such a lot, it works perfectly.

Regards,

Matt

No probs Matt ! God Luck !

PS: If you are from UK, please check out Calling all members in UK