This content has been marked as final. Show 9 replies
I have a following query in SQL server:
SELECT * FROM TABLE_A
DESCRIPTION NOT LIKE '%[^a-z]cos[^a-z]%'
So this query will return values only if it has the text COS as a whole, without any characters [a-z] before or after that.
If I use WILDMATCH ( DESCRIPTION, '*COS*'), it returns rows that have have words like 'ECOSYSTEM' which has characters [a-z] before and after. This is not desirable.
|DESCRIPTION||SQL SERVER||QV WILDMATCH|
So my question is what is the correct function or method in qlikview that will return exact same result as the SQL SERVER query I have above.