1 Reply Latest reply: Apr 18, 2013 12:36 AM by 937325 RSS

    elimination of numbers in prompts

    Mano
      Dear All

      We have a requirement where in one column we have values like below.

      01
      02
      03
      .45
      .97
      19.01
      22.02
      PRM
      PRS
      CEB etc .. Now our user doesnt want any of those numbers to appear in the prompts while selecting the values. They want only PRM , PRS , BNS such characters to appear when they select the multiselect option to pick up the values at prompts.

      Now which function can i use and how can i eliminate numbers so that user doesnt see any of these numbers in the list of values?

      Please help me as this is quite urgent.

      Regds
      Mano
        • 1. Re: elimination of numbers in prompts
          937325
          Hi,


          change the column datatype to char using cast function,

          then in prompt selct the values using SQL and write the sql statment by applying the substring function SUBSTRING("COLUMN NAME" FROM 1 FOR 3) >= 'A' and SUBSTRING("COLUMN NAME" FROM 1 FOR 3) <= 'Z'.


          This might help you try and give me the update on this.

          Mark if Helpful/correct.


          Thanks.