When I go to run a query I get the following error message: "Query Syntax Error: There was an error with the expression. 1: near "ESCAPE": syntax error"
The problem was found using a SQL statement with two % wildcard characters in it. The original statement was:
Physical_PipeMaterial LIKE '%PN%'. This statement causes a problem, however, because it does not use an escape character to let SQL know to stop looking for a unlimited amount of characters before it gets to the 'PN%' part of the string. Using a escape character let's SQL's logic know when to stop.
Something like this should work: Physical_PipeMaterial LIKE '%/PN%' ESCAPE '/'
Query not returning results for fields that use a pick-list