4D v14

CONCAT

Home

 
4D v14
CONCAT

CONCAT  


 

 

Command CONCATCONCAT (arithmetic_expression, arithmetic_expression)

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;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
SEE ALSO 

CONCATENATE

 
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)