Operator "LIKE" in QlikView?

[magdagarcia]

Hi everyone;

can you help me please?

In SQL server exist the Operator "LIKE"

The LIKE operator is used in a WHERE clause to  search for a specified pattern in  a column.

Can you tell me how is call this Operator "LIKE" en Qlik View?

Becasue in Qlikview is not called "LIKE" is the other way and have different name.

Regards!!

[Gysbert_Wassenaar · Accepted solution]

There are several functions that can be used. Wildmatch and Substringcount are the two most often used.

Load Product, Sales

from ...somewhere...

where wildmatch(Product, '*phone', 'battery*','radio');

See the help file for more details.

[magdagarcia]

thanks very much !!! Regards!!!

done and work it!!!