Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. delimiter $
  2. create function f_insertar_mayusculaMinuscula_Empleado(_id_empleado int) returns varchar(70)
  3. begin
  4. declare salida varchar(70);
  5. declare i int;
  6. set i = 1;
  7. select concat_ws(" ",Trim(nombre),Trim(apellido_paterno),Trim(apellido_materno)) into @nombre from empleado where id_empleado = 1; /*_id_empleado;*/
  8. select CHARACTER_LENGTH(@nombre) into @num_Caracteres;
  9. set salida = @nombre;
  10. repeat
  11. if(select substring(@nombre,i,1 = ' '))then
  12. set salida = salida + upper(substring(@nombre,i+1,1));
  13. set i = i + 1;
  14. else
  15. set salida = salida + lower(substring(@nombre,i,1));
  16. set i = i + 1;
  17. end if;
  18. until i <= @num_Caracteres
  19. end repeat;
  20. return salida;
  21. end $
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement