Adaptive Server version allows you to treat square brackets individually in the like pattern-matching algorithm.
For example, matching a row with ‘[XX]’ in earlier versions of Adaptive Server required you to use:
select * from t1 where f1 like '[[]XX[]]'
However, in Adaptive Server 15.7, you can also use:
select * from t1 where f1 like '[[]XX]'
Because of the need for full compatibility, this feature is available only in Adaptive Server version 15.7 by enabling the command:
sp_configure “enable functionality group”, 1
If you do not enable this feature, the behavior of like pattern-matching for square brackets is as in previous releases.
When you enable this feature:
like pattern-matching
allows a closing square bracket (“]”)
immediately following an opening bracket (“[”)
to stand for itself, so that the pattern “[]]” matches
the string “]”.
An initial caret (“^”) inverts the sense in all character ranges, so that the pattern “[^]]” should match any single character string that is not “]”.
In any other position, the closing bracket (“]”)
marks the end of the character range.
The patterns that work when you enable -T4086 are:
Pattern |
Matches |
|---|---|
“ |
“ |
“ |
“ |
“ |
“ |
“ |
“ |
“ |
“ |
