match with * ??

[#1]

Hi everybody i have a little question about  match function and the * ( for example in SQL it may be something like this WHERE NAME = GO* and it selects all names that start with GO

is it possible this with the match function in QV? for example

WHERE MATCH(NAME, ´AL*´, ´PO'; )

etc...

Thank you all!

[Gysbert_Wassenaar · Accepted solution]

In Qlikview you can use the wildmatch function for wildcard matching.

[#3]

Thank you, then i have to do the same thing that i did with match but with WILDMATCH?

[Gysbert_Wassenaar]

Yes, that's right.

[#5]

Thank you.

I´ll put a simple example , maybe this would help somebody.

FROM

xxxx.qvd

Where WildMatch(account, '2103*', '2108*', '2104*', '21021*', '21004*');