CHAR

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


CHAR (arithmetic_expression)

Description

The CHAR function returns a fixed-length character string based on the type of the arithmetic_expression passed.

Example

This example returns a character string based on the integer of the first letter of each last name:

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

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next