Graham T
Registered User.
- Local time
- Today, 01:29
- Joined
- Mar 14, 2001
- Messages
- 300
Just a quick question:
When using the In operator, can the list of values contain the wildcard (*).
A colleague is using an OR operator that is creating a very long criteria and I thought of using the In operator.
However the values she is entering contain * as she is searching on postcodes.
I have tried this using an example of:
In ("NG*", "DD*") and it is not returning any values.
TIA
When using the In operator, can the list of values contain the wildcard (*).
A colleague is using an OR operator that is creating a very long criteria and I thought of using the In operator.
However the values she is entering contain * as she is searching on postcodes.
I have tried this using an example of:
In ("NG*", "DD*") and it is not returning any values.
TIA