I am using a parameter to pass the search criteria to crystal. I search a database field for this string. The parameter can be any length and upper or lower case. Same thing with the database field. I put the following formula in the record select. I am uppercasing the parameter and the database field before doing the string function. It does not do the uppercasing. Do you know how else to accomplish this?  Thanks.

Edited by Debh - 10 Mar 2008 at 11:44am

I was looking for a way to search from a parameter into a string. InStr({?Param}

But it still was only searching lowercase or uppercase. Not both. So doing 2 uppercase functions in the formula field as you suggested worked perfect.

Record Select:
InStr({Uppercase String}),{@Uppercase Search}) > 0