MattAnderson
Registered User.
- Local time
- Today, 03:43
- Joined
- Mar 10, 2014
- Messages
- 11
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
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