Illegal LIKE pattern

The pattern specified for a Like operation is illegal for one of the following reasons:

  • You specified a range of characters in brackets, but the second character is earlier in the collating sequence than the first character. For example:
    "a" Like "[e-a]"

    Reverse the order of the characters in the illegal range specification.

  • You specified an open bracket without a close bracket. For example:
    "a" Like "[abc"

    Supply the close bracket. If you want to specify an open bracket as a character to match, enclose it in brackets:

    "[" Like "[[]"