Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
WHERE LIKE Command not accepting wildcard
Jonathan_Thomson_(jonathanthomson_-_(deleted))
I get an error message when using the SQL line...WHERE Audit_Status Like 'OP%'The message states [[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'OP?'OP%' stands for "Open" or "Open Pending Review", etc.How can i apply a wildcard?
Find more posts tagged with
Comments
Jonathan_Thomson_(jonathanthomson_-_(deleted))
Use 'OP%%'.
Louis_Routhier
Since the context wasn't define and that it may bug some people, I thought I should mention it. This is due to the fact that in LiveReports, %1 %2, ... %9 are used to parameterize queries so when the parser encouters % alone, it takes the character with it
