Wildcard with Parameter

[webfocusraj]

Hi,
Enviroment: WF Dev studio 5.2
If I want to see all the employees whose lastname starts with "S", I did the following thing:
WHERE LAST_NAME EQ 'S$*';
This is working fine.
Now, I want to prompt the user the first letter of the employee's lastname, I did in the following way:
WHERE LAST_NAME EQ '&LNAME$*'; ("LNAME" is the parameter)
This thing doesn't work !!!
Please help me.
Regards
WFRAJ

 

[simaccs]

Hi,

Try this.

WHERE LAST_NAME EQ '&LNAME.EVAL$*'
or
WHERE EDIT(LAST_NAME,'9') EQ '&LNAME'

Can these work in your enviroment?

sim

 

[webfocusraj]

Hi Sim,
Its working.
I appreciate your help.
I am new to WF and I would need the help of people like you.
Thank you very much
regards
WFRAJ

 

[MichaelHuber]

Yet another solution might be:

-SET &LNAME = &LNAME | '$*';
TABLE FILE ...
...
WHERE LAST_NAME EQ '&LNAME'


Sometimes WebFOCUS will offer you a few solutions to your problems. We're using a similar method to allow for "optional parameters" if anyone is interested:
-SET &LNAME = IF &LNAME2 EQ ' ' THEN '$*' ELSE &LNAME2

WebFOCUS propmts the user for LNAME2, then uses LNAME in the WHERE. If LNAME2 is blank, the report selects all names.
Regards,
Michael

 

[webfocusraj]

Hi Michael,
Even your thing works !!
Thankyou very much.
regards
WFR