How to use % in command statement

[vega83]

Hello friends I am trying to use % for all in command statement
in where caluse I have
AND B.County_Id in {?County} or {?County} = '%'
B.County_Id is numeric and {?County} is string. Any ideas?.

I also tried
cast(B.COUNTY_ID as varchar(32)) in {?County} or {?County} = '%'

 

[vega83]

Please ignore
I use CHAR(field) like '?param' it worked