nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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