Skip to content

Instantly share code, notes, and snippets.

@maxwellcc

maxwellcc/capitalize_person_names_ptBR.sql

Last active September 6, 2022 12:37
Show Gist options
  • Save maxwellcc/5a4971c859c6921a31e7ceac2fa8bf7a to your computer and use it in GitHub Desktop.
Save maxwellcc/5a4971c859c6921a31e7ceac2fa8bf7a 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