Concatenation Operator || in Teradata

Concatenation Operation in Teradata joins two strings provided inside the single quote. Concatenation operator works similar to CONCAT function. This operator mainly used in the SELECT statement.

Concatenation is the process of combining two or more column into one single column. This function has the backward compatibility, so use || operator whenever you need to concatenate any string.

Example

SELECT 'Teradata ' ||'Point'

Output

Teradata Point