V
Vilem Sova
I need to be able to filter the contacts list by a range of postal/zip
codes. eg 1500 to 1920, 2000-2249
1. Sometimes it will be easier to use a single-character wild character but
I don't know what it is. The '%' character is a multi-character wildcard, so
is not suitable in some circumstances.
2. At other times it will be easier to use something like
'1[5-9][0-9][0-9]'. Is this possible?
3. Is it also possible to do something like...BETWEEN '1500' AND '1920'?
I've tried this syntax but Outlook won't accept it.
What is the proper way of editing the SQL in the advanced filtering option
to do these types of wildcard filtering?
Thanks,
Vilem Sova
Canberra, Australia
codes. eg 1500 to 1920, 2000-2249
1. Sometimes it will be easier to use a single-character wild character but
I don't know what it is. The '%' character is a multi-character wildcard, so
is not suitable in some circumstances.
2. At other times it will be easier to use something like
'1[5-9][0-9][0-9]'. Is this possible?
3. Is it also possible to do something like...BETWEEN '1500' AND '1920'?
I've tried this syntax but Outlook won't accept it.
What is the proper way of editing the SQL in the advanced filtering option
to do these types of wildcard filtering?
Thanks,
Vilem Sova
Canberra, Australia