Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save ernestoruiz89/9d92c92343ebd374e13ce1a2b6b2ac4d to your computer and use it in GitHub Desktop.
Save ernestoruiz89/9d92c92343ebd374e13ce1a2b6b2ac4d to your computer and use it in GitHub Desktop.
* Calcular la letra al final de la cédula nicaragüense.
* La letra se calcula con el siguiente algoritmo (SQL).
*
* declare @cedula varchar(20),
* @val numeric(13, 0),
* @letra char(1),
* @Letras varchar(20)
*
* select @Letras = 'ABCDEFGHJKLMNPQRSTUVWXY'
* select @cedula = '0012510750012' --PARTE NUMERICA DE LA CEDULA SIN GUIONES
* --CALCULO DE LA LETRA DE LA CEDULA
* select @val = convert(numeric(13, 0), @cedula) - floor(convert(numeric(13, 0), @cedula) / 23) * 23
* select @letra = SUBSTRING(@Letras, @val + 1, 1)
* select @letra
*
* @return Letra válida de cédula dada
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment