6 Replies Latest reply: Jul 20, 2017 10:02 PM by Cherry B RSS

    Could you help me do Wildmatch with the value of a column?

    Cherry B

      I was have a table

      SAMPLE.PNG

      SQL SELECT Track,

                          Proc_ID,

                          Qty

      FROM "SQL_A".dbo."Data_Track";

       

      I would like to locate all that has '*_TM_*' whether it is a lowercase or an uppecase

      I will be creating another column for the result which is the showme field


      I have this script

       

      If(WildMatch([Proc_ID],'*_TM_*'), (Qty+7)*2, If(WildMatch([Proc_ID],'*_0*'), (Qty+7)*5, 'Nothing Found')) as showme


      Upon Running I had this error

      ErrorMsg: 'WildMatch' is not a recognized built-in function name


      Please help, I'm confused. Thanks.