From The Document Foundation Wiki
Jump to: navigation, search

For "LIKE" criteria, this is a bit confusing as to whether the quotation marks round the % signs are part of the text to be typed or not. It also seems (from a bit of experimentation) that you need to explicitly concatenate the percent signs with the parameter prompt. I suggest adding an example. There may be a problem her in that different databases have different concatenation syntax. May I suggest (I'm a newbie here, so don't want to edit without some agreement from the experts) something like

LIKE '%' || :Parameter_prompt || '%'

with a comment that different databases may use different concatenation syntax?