Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delimiter $
- create function f_insertar_mayusculaMinuscula_Empleado(_id_empleado int) returns varchar(70)
- begin
- declare salida varchar(70);
- declare i int;
- set i = 1;
- select concat_ws(" ",Trim(nombre),Trim(apellido_paterno),Trim(apellido_materno)) into @nombre from empleado where id_empleado = 1; /*_id_empleado;*/
- select CHARACTER_LENGTH(@nombre) into @num_Caracteres;
- set salida = @nombre;
- repeat
- if(select substring(@nombre,i,1 = ' '))then
- set salida = salida + upper(substring(@nombre,i+1,1));
- set i = i + 1;
- else
- set salida = salida + lower(substring(@nombre,i,1));
- set i = i + 1;
- end if;
- until i <= @num_Caracteres
- end repeat;
- return salida;
- end $
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement