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.
Leading and trailing white space must be ignored. Internal white space characters must be coerced to spaces. Sequences of two or more spaces must be condensed into a single space. Case distinctions must be maintained for comparison purposes.
After white space processing, implementations may consider only a leading, fixed number of characters to be significant. The number of signficant characters must be equal to the minimum number of significant characters over which the pattern match occurs. For example, a stringLike value intended for use on an operationTarget must maintain as many significant characters as an operationTarget does.
Please note that the stringLike type defines only semantic meaning beyond the basic schema string type. It exists to flag these additional semantics and to ease future modifications.
![]() |
|
![]() |
![]() |
![]() |