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!
Try: ... LIKE '%' || ?parm? || '%'
Quote from: rockytopmark on 18 Oct 2007 12:41:08 PM
Try: ... LIKE '%' || ?parm? || '%'
it can work! thank you very much!!!!