Skip to content

Instantly share code, notes, and snippets.

@tkMageztik

tkMageztik/fn_genera_iniciales.sql

Created August 24, 2012 17:42
Show Gist options
  • Save tkMageztik/3453333 to your computer and use it in GitHub Desktop.
Save tkMageztik/3453333 to your computer and use it in GitHub Desktop.
Download ZIP
Genera iniciales en base a una palabra. V1, por refactorizar
Raw
fn_genera_iniciales.sql
update tabla
set tabla_descripcion=
(case when PATINDEX('% %',tabla_descripcion) > 0
then left(tabla_descripcion,4) +'. '+
left(substring(tabla_descripcion,PATINDEX('% %',tabla_descripcion)+1,LEN(tbien_descripcion)),4)+'.'
else left(tbien_descripcion ,4) +'. '
end )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment