>>I have created a view that asks the user to enter a Fiscal Year, e.g.
>>
>>prcFiscalYear LIKE ?'Fiscal Year Surrounded by % (e.g. %98%)'
>>
>>The view when used comes up and asks the appropriate question, but my user does not want to enter the %, they just wish to enter the 98. So how can I have a parameter that comes up with a question, but after the user enters the fiscal year slaps a '%' on the front and back of what they entered. Any help would be appreciated. Or send me in another direction on getting user input in a parameterized view.
>
>prcFiscalYear LIKE "%"+?'FiscalYear Please'+"%"
>Cetin
Thanks Cetin you led me in the right direction I used what was above, but when entering the fiscal year 99 or 98 it was being interpreted as a numeric, so I changed it to:
prcFiscalYear LIKE "%"+ALLTRIM(STR(?'Fiscal Year (e.g. 97,98,..)'))+"%"
And now it works like a charm.
Thanks again.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope