Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...
In Teradata, we can use concatenation operator to link multiple string or numeric or expression values into single value. Input for concatenate can be two or more but output of concat is always one. In Teradata, concatenate operator is represented by "||" i.e two vertical lines. You can also use '!!' i.e. two exclamation mark however it is not recommended to use it. In this post we will see syntax and examples of various scenarios where concatenate can be used.
Reference : https://etl-sql.com/teradata-concaten...