The + operator can be used to concatenate string in legacy SQL but in standard SQL CONCAT function has to be used:
#standardSQL
SELECT CONCAT('UNITED',' ','STATES')
The LENGTH function returns the length of the string passed as argument. The following query returns 5 as output:
SELECT LENGTH('INDIA')
The REPLACE function will replace the specified text with the replacement text. The following query will output *****@collegecronista.com this value:
SELECT REPLACE('[email protected]','reachme','*****')
The SPLIT function splits the string by delimiter specified and returns an array of values. The output of the query is shown in the following screenshot:
#standardSQL
SELECT SPLIT('1,2,3,4,5,6',',')
