4D v14

ASCII

Home

 
4D v14
ASCII

ASCII  


 

 

Command ASCIIASCII (arithmetic_expression)

The ASCII function returns the leftmost character of the arithmetic_expression as an integer. If the arithmetic_expression is null, the function will return a NULL value.

Example  

This example returns the first letter of each last name as an integer:

SELECT ASCII(SUBSTRING(LastName,1,1))
FROM PEOPLE;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)