SPACE

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

version 11


SPACE (arithmetic_expression)

Description

The SPACE function returns a character string made up of the given number of spaces indicated in arithmetic_expression. If the value of the arithmetic_expression is less than zero, a NULL value will be returned.

Example

This example adds three spaces in front of the last names of the PEOPLE table:

   SELECT CONCAT(SPACE(3),PERSONS.LastName) FROM PEOPLE;

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