topic Is there a similar function to SQL 'LIKE' in QlikView script? in QlikView https://community.qlik.com/t5/QlikView/Is-there-a-similar-function-to-SQL-LIKE-in-QlikView-script/m-p/177777#M45240 <HTML><HEAD></HEAD><BODY><P>Matt,</P><P>try WILDMATCH</P><P>cheers</P></BODY></HTML> Mon, 07 Dec 2009 21:55:57 GMT Oleg_Troyansky 2009-12-07T21:55:57Z Is there a similar function to SQL 'LIKE' in QlikView script? https://community.qlik.com/t5/QlikView/Is-there-a-similar-function-to-SQL-LIKE-in-QlikView-script/m-p/177776#M45239 <HTML><HEAD></HEAD><BODY><P>I have a field that I need to interrogate.</P><P>If it contains a certain string then it needs to do a 'textbetween' function on 2 characters, if it contains a different string then it does a 'textbetween' on 2 other characters.</P><P>logically I want to say:<BR />if field TEXTCOL LIKE '%changed the field% then do this</P><P>else if field TEXTCOL LIKE '%user-defined%' then do that.</P><P></P><P>...if that makes sense...</P><P>thank in advance,</P><P>Matt</P></BODY></HTML> Mon, 07 Dec 2009 21:47:42 GMT https://community.qlik.com/t5/QlikView/Is-there-a-similar-function-to-SQL-LIKE-in-QlikView-script/m-p/177776#M45239 2009-12-07T21:47:42Z Is there a similar function to SQL 'LIKE' in QlikView script? https://community.qlik.com/t5/QlikView/Is-there-a-similar-function-to-SQL-LIKE-in-QlikView-script/m-p/177777#M45240 <HTML><HEAD></HEAD><BODY><P>Matt,</P><P>try WILDMATCH</P><P>cheers</P></BODY></HTML> Mon, 07 Dec 2009 21:55:57 GMT https://community.qlik.com/t5/QlikView/Is-there-a-similar-function-to-SQL-LIKE-in-QlikView-script/m-p/177777#M45240 Oleg_Troyansky 2009-12-07T21:55:57Z