Concatenation Operator || in Teradata

Concatenation operator joins two string, concatenation operator is similar to CONCAT function.

Concat function is provided as backward compatibility, so use || operator wherever concatenation is needed.

SELECT 'Forget '||'Code'


Output
Forget Code