Temple University

Concatenation means putting two character strings together to form one character string. The SQL concatenation operator is +. Note that if you want to concatenate a numeric value (with anything), you must first convert the number to a character string. In the example below, you concatenate city, state, and zip code (converted to character ... ................
................