Characters

In this section: Letters Digits Special Characters

Characters are the fundamental building blocks of the SQL language. The user can compose names, phrases, expressions, literals, and other higher-level constructs with them. Upper and lower case letters, spaces, digits, and new line markers are all in the SQL character set, as are a variety of special symbols.

Letters

alpha  ::=  A..Z  |  a..z

Note: A..Z means any character from A to Z.

Digits

digit  ::=  0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9| 0...9

digit  ::=  0...9

Special Characters

special-character ::=

A special character is any character in the character set of a server other than a digit or an alpha.

<blank> ::=

<double quote> ::= "

<percent> ::= %

<ampersand> ::= &

<quote> ::= '

<left paren> ::= (

<right paren> ::= )

<asterisk> ::= *

<plus sign> ::= +

<minus sign> ::= -

<period> ::= .

<solidus> ::= /

<colon> ::= :

<semi-colon> ::= ;

<less than operator> ::= <

<equals operator> ::= =

<greater than> ::= >

<question mark> ::= ?

<left bracket> ::= [

<right bracket> ::= ]

<underscore> ::= __

<vertical bar > ::= |

<caret> ::= ^