
Not applicable
2012-07-11
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using MATCH and wildcards
Hi everyone,
How could I search for all strings within OCWard which start with A and end with E? I was using this: -
,IF(MATCH(dept,'A&E','1'), 1,
IF(MATCH(OCWard,'A*E','ED'), 1,
IF(OCDestinationCode='1',0))) as ED_Ward2
But it doesn't find AYE, or A&E etc. What am I doing wrong?
Many thanks in advance.
5,378 Views
2 Replies


Specialist III
2012-07-11
10:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to use
IF(WILDMATCH(OCWard,'A*E','ED'), 1,
and see if it works

Not applicable
2012-07-11
10:56 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi krishnamoorthy,
Works perfectly! Thank you very much.
4,179 Views
