How to use CONCAT with + in BigQuery

Question

I tried using CONCAT with + sign in SQL, however I am not getting the correct syntax to perform this query. The tool that I am using is Google BigQuery.

Answer 1

To concatenate strings in BigQuery, we can either use the CONCAT() function, or we can use the || ANSI concatenation operator:

SELECT CONCAT('Hello', 'World')
SELECT 'Hello' || 'World'

Other databases such as SQL Server use the + operator for string concatenation, but not BigQuery.