Skip to content

Instantly share code, notes, and snippets.

@maxwellamaral

maxwellamaral/capitalize_person_names_ptBR.sql

Forked from maxwellcc/capitalize_person_names_ptBR.sql
Created September 6, 2022 12:37
Show Gist options
  • Save maxwellamaral/f2e385e61160d0035b1e4ceba9dbc9dd to your computer and use it in GitHub Desktop.
Save maxwellamaral/f2e385e61160d0035b1e4ceba9dbc9dd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
capitalize_person_names_ptBR.sql
update tabela
set nome = (replace(replace(replace(regexp_replace((initcap(nome)), '[^A-zÀ-ú]', ' ', 'g'),' Do ', ' do '), ' De ', ' de '), ' Da ', ' da '))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment