like statement use in prompt page

[silywiwi]

hi,all!
   I have a requirement to make a indistinct query,so i use the 'like ' statement , and i use the prompt page
   the statement looks like below:
   [name] like ?para?
  when i  use para query in prompt page ,it does not work except for entering a full name or insert % into head and rear of the name

my question is that how to add % into statement which can make % useful.
[name] like ?%para%?   and   [name] like %?para?%  both cannot work.  

thinks in advance!

[rockytopmark]

Try: ... LIKE  '%' || ?parm? || '%'

[silywiwi]

Try: ... LIKE  '%' || ?parm? || '%'

it can work!  thank  you very much!!!!