CONCAT

Learn how to use the CONCAT string function in PlaidCloud Lakehouse. Concatenates two or more strings - see syntax, examples, and output.

Concatenates two or more strings.

Analyze Syntax

func.concat(<str1>, <str2>[, ...])

Analyze Examples

func.concat('Star', 'Rocks')

┌─────────────┐
 'StarRocks'  
└─────────────┘

SQL Syntax

CONCAT(<str1>, <str2>[, ...])

SQL Examples

SELECT CONCAT('Star', 'Rocks');

┌───────────┐
 StarRocks  
└───────────┘