CHECK_94 - Check String literals with LIKE, CP, NP
Improve this page
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*'.