Changes to like Pattern Matching

Adaptive Server version 15.7 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]'