Skip to content

Instantly share code, notes, and snippets.

@mbforr

mbforr/left.sql

Created July 6, 2021 19:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mbforr/5004962ef32fd45e4d8ca6dcb8039e6d to your computer and use it in GitHub Desktop.
Save mbforr/5004962ef32fd45e4d8ca6dcb8039e6d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
left.sql
select
state_name,
# left will return the first letter of the text in the state_name column
left(state_name, 1) as first_letter
from
`bigquery-public-data.geo_us_boundaries.states`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment