3 Replies Latest reply: Sep 22, 2017 3:32 PM by Sunny Talwar RSS

    Using 'Like' in SQL 'Where' statement

    Linda Pembroke

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