1 2 Previous Next 20 Replies Latest reply on Oct 25, 2018 8:19 AM by Kamil Kobierski

    Case statement with "CONTAINS" function

    Chuck Blechle

      Case [SERVICE_DESCRIPTION]

      When CONTAINS "*BL1*" then "BL1"

      else ""

      end

       

       

      Trying to identify if a string has "BL1" anywhere within the string and if so return "BL1" but I keep getting compile errors.

        1 2 Previous Next