all or part of a parameter

[Spenello]

Crystal 8.5 Oracle 10g database
The Record Selection formula goes like this below. It is one of many other parameters that will display specific results if something is entered in the Parameter Values window, otherwise results are displayed not using parameter.
(UPPERCASE({TRANSACTIONLOG.DESCRIPTION}) = UPPERCASE({?Description}) or UPPERCASE({?Description}) = "")
Formula {?Description}:
If uppercase({?Description}) = ' then "No Description Selected"
else uppercase({?Description})
What I want to know is, how to wildcard the parameter so that a user can enter all or part of a description and get proper results.
i.e. enter "Description" in parameter and get Description in results.
i.e. enter "desc" in parameter and get Description in results.

 

[lbass]

(
UPPERCASE({TRANSACTIONLOG.DESCRIPTION}) like
UPPERCASE({?Description})+"*" or
trim({?Description}) = ""
)

-LB

 

[Spenello]

Thanks lbass, that worked!