SQL Concatenation #

There are a few ways to do it (and it varies by SQL dialect)

SELECT 'a' || 'b' as concatenated
-- returns 'ab'