Forum Stats

  • 3,874,599 Users
  • 2,266,752 Discussions
  • 7,911,910 Comments

Discussions

elimination of numbers in prompts

Mano
Mano Member Posts: 100
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

Answers

  • 937325
    937325 Member Posts: 159
    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.
This discussion has been closed.