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]'