CONCAT

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

version 11


CONCAT (arithmetic_expression, arithmetic_expression)

Description

The CONCAT function returns the two arithmetic_expression type arguments passed as a single concatenated string.

Example

This example will return the first name and last name as a single string:

   SELECT CONCAT(CONCAT(PEOPLE.FirstName,' '), PEOPLE.LastName) FROM PERSONS;

See Also

CONCATENATE.


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