4D v13.4

SPACE

Home

 
4D v13.4
SPACE

SPACE  


 

 

Command SPACESPACE (arithmetic_expression)

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;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands