1 2 Previous Next 21 Replies Latest reply on Jul 12, 2019 12:57 AM by Prashant S

    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