Big query - Concatenate strings horizontally
You need to use CONCAT and the trim functions
SELECT CONCAT(rtrim(ltrim(first_name)),' ',rtrim(ltrim(last_name))) AS full_name
FROM
(SELECT 'Anna' AS first_name,
' Miller ' AS last_name),
You need to use CONCAT and the trim functions
SELECT CONCAT(rtrim(ltrim(first_name)),' ',rtrim(ltrim(last_name))) AS full_name
FROM
(SELECT 'Anna' AS first_name,
' Miller ' AS last_name),