Topic: Using Like operator with parameter Posted: 14 Apr 2010 at 5:32am
Is there a way to use the Like Operator with a Parameter field? I have a Parameter, {?CRA}, which has a list of default values. The field that I want to use {?CRA} with is IDB. It has entries such as 1FDG or 25BK163g. There are thousands of variations but the default values in the parameter, in this case would be, FDG and BK. A user will need to find all of the records in IDB with FDG and BK somewhere in the field using a drop down box. I cannot possibly import all of the thousands of variations into the default value list in {?CRA} so I was wondering if there was a way to select IDB = *{?CRA}* or IDB Is Like {?CRA}?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum