charlist definition

A group of one or more characters enclosed by [ ] as part of Like operator's right string expression.

  • This list contains single characters and/or character ranges which describe the characters in the list.
  • A range of characters is indicated with a hyphen (-) between two characters. The first character must be ordinally less than or equal to the second character.
  • Special pattern characters like ?, *, # and [ can be matched as literal characters.
  • The ] character can not be part of charlist, but it can be part of the pattern outside the charlist.