Crystal Report - using wild characters in selection parameter

[#1]

I need to know the syntax on using sild characters in a range of inputs. For example, I have a begPart and End part inputs. I want the ability to use wild character to give me a selection that would include *Oil or Filter * (this would give me all parts that start with Filter).

[Former Member]

Something like this...

{TableName.FieldName} like "*" & {?My Parameter} & "*"

HTH,

Jason

[Former Member]

wildcard in crystal syntax is *

field like ["*oil*","*filter*"]  // will return values containing oil or filter

field like "filter*"   // with return values starting with filter

field like ["*oil","filter*"]  
// will return values ending with oil or starting with filter