Is there any alternative for "InStr() Sql Function" in Qlikview?

[#1]

Hi, I have the following status for my records:

• BLOQ. A
• BLOQ. B
• C BLOQ.
• CTEC A
• CTEC BLOQ.

Well, I want to filter each record that contains "BLOQ" inside status value. In SQL exists the "InStr()" function but I haven't found any similar function in qlikview.

[marcus_sommer]

Have a look on match() and wildmatch().

- Marcus

[maxgro · Accepted solution]

where     wildmatch(status, '*BLOQ*')

[MarcoWedel]

To find the position of a substring in a string you can use the Index() function in QlikView.

So this would be the equivalent to the SQL InStr() function.

hope this helps

regards

Marco

[#5]

Many thanks, thats just that i've been triying to find.