Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thank you for your code suggestion, and I deleted the access2base tag that was in error.

When I entered that code into my query criteria SQL the double “%” acted like 2 wildcards. So, entering 17 at the prompt, returned 0017, 0117, xx17….. and all of the 17xx rows from my table. In effect, it seems to be equivalent to %17%.

Removing the '%' || from the beginning of the LIKE statement seems to fix this issue. Entering 17 now returns all records with 17xx rows.

SELECT * FROM “YOUR_TABLE” WHERE “YOUR_FIELD” LIKE :EnterClaimNumber || '%'

Can you explain the function of || which I do not understand?