Help on Prompts?

[anumala28]

Hi,

I need filter the data ends with < prompt value>

exe: like '%3'

Insted of using 3 i am using prompt value


Here the problme is How should i write filter using prompt value.


Thanks,
Sri

 

[nagrajm]

There are many ways to accomplish this I am sure. One way would be

Right(Data,1) = ?prompt? or Substr(Data,n,1) = ?prompt?

where n is the length of the string that you want to test.

 

[anumala28]

Thansk for your replay,