ascii

Syntax

ascii(char_expr | uchar_expr)

Parameters

• char_expr – is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.
• uchar_expr – is a character-type column name, variable, or constant expression of unichar or univarchar type.

Examples

• Example 1 – Returns the author’s last names and the ACSII codes for the first letters in their last names, if the ASCII code is less than 70:

  select au_lname, ascii(au_lname) from authors
  where ascii(au_lname) < 70

   au_lname
   ------------------------------ -----------
   Bennet                                 66
   Blotchet-Halls                         66 
   Carson                                 67 
   DeFrance                               68 
   Dull                                   68 

Usage

When a string function accepts two character expressions but only one expression is unichar, the other expression is “promoted” and internally converted to unichar. This follows existing rules for mixed-mode expressions. However, this conversion may cause truncation, since unichar data sometimes takes twice the space.

If char_expr or uchar_expr is NULL, returns NULL.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute ascii.