I have an SQL query as " select x,y,z from tablename where column_name like '%ar%ul%' "
How to write the above query in Qlikview Script?
Any help is greatly appreciated
Sorry, a small addition to the above query -- select x,y,z from tablename where column_name1 like '%ar%ul%' and column_name2 not like '%mag%'
Something like this:
load x,y,z from tablename
where wildmatch(column_name1, '*ar*ul*') and not wildmatch(column_name2, '*mag*');
Yes, it worked perfectly. Thanks Gysbert
you can do this too
WHERE FIELD_1 LIKE '*ar*ul*'
AND FIELD_2 NOT (LIKE '*mag*')
Retrieving data ...