Hi all

I am working on a user interface and having an issue. there is a multi select listbox which sends its values in this format to the report

  
'Value1' OR 'Valu2' OR 'Value3'

I am trying to write dialog manager commands to append % symbl at the end of each value to get it like this.

  
'Value1%' OR 'Value2%' OR 'Value3%'

Can someone help on this?

thank you

This message has been edited. Last edited by: Kerry,

Perhaps something like this:

-SET &Rep1 = STRREP (&Var.LENGHT,&Var,4,''' OR',5,'%'' OR',100,'A100') ;
-SET &Rep1 = TRUNCATE(&Rep1);
-SET &Len1 = &Rep1.LENGTH - 1 ;
-SET &Rep2 = SUBSTR(&Rep1.LENGTH,&Rep1,1,&Len1,&Len1,'A&Len1.EVAL') | '%''' ;

thanks waz...this worked..
i was able to get first 2 steps but been struggling for 3rd and 4th..

3rd and 4th steps ?