Choose Category
SELECT CONCAT('string1' or number1,'string2' or number2)
SELECT CONCAT('Tera','data')
Result: Teradata
SELECT CONCAT('Tera','data',11)
Teradata 11 //(Spaces are there in the output)
SELECT CONCAT(7777,999,11)
Teradata 7777 999 11 //(Spaces are there in the output)
SELECT CONCAT('7777','999','11')
Teradata 777799911 //(Numbers are represented here in string format)