Big Query - Concatenate Strings Horizontally
Answer : 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),