SQL language characters

SQL keywords, Transact-SQL extensions, and special characters such as the comparison operators > and <, can be represented only by 7-bit ASCII values A– Z, a –z, 0–9, and the following ASCII characters:

Table 1-1: ASCII characters used in SQL

character

description

;

(semicolon)

(

(open parenthesis)

)

(close parenthesis)

,

(comma)

:

(colon)

%

(percent sign)

-

(minus sign)

?

(question mark)

(single quote)

"

(double quote)

+

(plus sign)

_

(underscore)

*

(asterisk)

/

(slash)

(space)

<

(less than operator)

>

(greater than operator)

=

(equals operator)

&

(ampersand)

|

(vertical bar)

^

(circumflex)

[

(left bracket)

]

(right bracket)

@

(at sign)

~

(tilde)

!

(exclamation point)

$

(dollar sign)

#

(number sign)

.

(period)