topic Re: Using 'Like' in SQL 'Where' statement in QlikView

Using 'Like' in SQL 'Where' statement

byrnel0586 — Fri, 22 Sep 2017 19:24:15 GMT

Hi,

I am using the below script and the "LOB_ID" Like '7*' piece is returning no results when I know there should be. Can someone please let me know what I may be doing wrong?

SQL SELECT

"EFF_DT",

"PCP_ID" AS mms_PCP_ID,

"VEND_ID" AS mms_VEND_ID,

"LOB_ID" AS mms_LOB_ID,

"MEM_ID" AS mms_MEM_ID

FROM DWDB.DBO."DW_MEM_MONTH"

WHERE "EFF_DT" >= 42979 AND "EFF_DT" <= 43008 AND "LOB_ID" LIKE '7*';

Thanks!!

Re: Using 'Like' in SQL 'Where' statement

sunny_talwar — Fri, 22 Sep 2017 19:26:50 GMT

Try with % for WildCard

SQL SELECT

"EFF_DT",

"PCP_ID" AS mms_PCP_ID,

"VEND_ID" AS mms_VEND_ID,

"LOB_ID" AS mms_LOB_ID,

"MEM_ID" AS mms_MEM_ID

FROM DWDB.DBO."DW_MEM_MONTH"

WHERE "EFF_DT" >= 42979 AND "EFF_DT" <= 43008 AND "LOB_ID" LIKE '7%';

Re: Using 'Like' in SQL 'Where' statement

byrnel0586 — Fri, 22 Sep 2017 19:29:43 GMT

Thanks, Sunny! I had been reading everywhere that SQL syntax isn't supported in the script so I didn't even think to try that. It is working perfectly now.

Re: Using 'Like' in SQL 'Where' statement

sunny_talwar — Fri, 22 Sep 2017 19:32:35 GMT

Actually anything you have after SQL SELECT needs to have SQL Syntax because if you don't (and use QlikView syntax) it won't work. Anything after SQL SELECT is sent to the database for querying and needs the SQL syntax.