Using 'Like' in SQL 'Where' statement

[byrnel0586]

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!!

[sunny_talwar · Accepted solution]

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%';

[byrnel0586]

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.

[sunny_talwar]

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.