Build a safe SQL LIKE filter: FieldName LIKE '%escapedValue%'
NOTE: EscapeSQLString neutralises quotes but NOT LIKE metacharacters — a value containing
%, _ or [ is still interpreted as a wildcard pattern rather than as literal text. That is
the long-standing behaviour of this helper and callers depend on it. If you need a literal
match, escape the metacharacters and add ESCAPE '\' (see escapeLikeValue() in
@memberjunction/core, generic/runQuerySQLFilterImplementations.ts).
Build a safe SQL LIKE filter: FieldName LIKE '%escapedValue%'
NOTE:
EscapeSQLStringneutralises quotes but NOT LIKE metacharacters — avaluecontaining%,_or[is still interpreted as a wildcard pattern rather than as literal text. That is the long-standing behaviour of this helper and callers depend on it. If you need a literal match, escape the metacharacters and addESCAPE '\'(seeescapeLikeValue()in@memberjunction/core,generic/runQuerySQLFilterImplementations.ts).