List of special characters for SQL LIKE clause

What is the complete list of all special characters for a SQL (I’m interested in SQL Server but other’s would be good too) LIKE clause?

E.g.

SELECT Name FROM Person WHERE Name LIKE '%Jon%'

SQL Server:

1. %
2. _
3. [specifier] E.g. [a-z]
4. [^specifier]
5. ESCAPE clause E.g. %30!%%’ ESCAPE ‘!’ will evaluate 30% as true
6. ‘ characters need to be escaped with ‘ E.g. they’re becomes they”re

MySQL:

1. % – Any string of zero or more characters.
2. _ – Any single character
3. ESCAPE clause E.g. %30!%%’ ESCAPE ‘!’ will evaluate 30% as true

Oracle:

1. % – Any string of zero or more characters.
2. _ – Any single character
3. ESCAPE clause E.g. %30!%%’ ESCAPE ‘!’ will evaluate 30% as true

Sybase

1. %
2. _
3. [specifier] E.g. [a-z]
4. [^specifier]

Progress:

1. % – Any string of zero or more characters.
2. _ – Any single character Reference Guide here [PDF]

PostgreSQL:

1. % – Any string of zero or more characters.
2. _ – Any single character
3. ESCAPE clause E.g. %30!%%’ ESCAPE ‘!’ will evaluate 30% as true

ANSI SQL92:

1. %
2. _
3. An ESCAPE character only if specified.

PostgreSQL also has the SIMILAR TO operator which adds the following:

3. [specifier]
4. [^specifier]
5. | – either of two alternatives
6. * – repetition of the previous item zero or more times.
7. + – repetition of the previous item one or more times.
8. () – group items together

The idea is to make this a community Wiki that can become a “One stop shop” for this.