CHECK_94 - Check String literals with LIKE, CP, NP
Improve this page![RFC-based](/img/rfc.png)
CODE
LIKE with wrong wildcard
SELECT ... WHERE xyz LIKE 'PATTERN*'.
instead of
SELECT ... WHERE xyz LIKE 'PATTERN%'.
NP or CP with wrong wildcard
IF xyz CP 'PATTERN%'.
instead of
IF xyz CP 'PATTERN*'.