We have a requirement where in one column we have values like below.
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.
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.