The stringLike type represents a string matching pattern similar to the pattern-expression semantics and syntax defined by the ANSI SQL92 LIKE predicate.
Within a stringLike value, the underscore character '_' matches any single character while the percent sign '%' matches a sequence of zero or more characters. Any other character represents itself.
The backslash '\' will always be the SQL92 LIKE escape-expression for the purposes of the stringLike types. This allows non-wildcard, literal uses of underscores and percent signs when they are preceeded by a backslash. Using a literal backslash requires doubling it as '\\' following from SQL92 escape-expression semantics.
![]() |
|
![]() |
![]() |
![]() |
![]() |