How to Convert the Case of a String

SQL Tutorial Home

BigQuery provides several case related functions as we can see in the following SQL example:

WITH schedules AS
  (SELECT 'Marlins' as homeTeamName, 'Cubs' as awayTeamName UNION ALL
   SELECT 'Braves', 'Cubs' UNION ALL
   SELECT 'Marlins', 'Braves' 
  )
SELECT lower(homeTeamName) AS lower,  
       upper(awayTeamName) AS upper, 
       initcap('hello') AS initcap 
FROM schedules
lower upper initcap
marlins CUBS Hello
braves CUBS Hello
marlins BRAVES Hello

IN THIS PAGE