debuger

[alkortius]

DELIMITER $$
DROP FUNCTION IF EXISTS SI.SOLO_CARACTERES $$
CREATE FUNCTION SI.SOLO_CARACTERES (VAR CHAR(100)) RETURNS CHAR(100)
DETERMINISTIC
BEGIN
DECLARE POS INT DEFAULT 1;
DECLARE TOTAL CHAR(100) DEFAULT '';
DECLARE VALOR INT DEFAULT 0;
REPEAT
IF INSTR('ABCDEFGHIJKLMNOPQRSTUVWXYZ', SUBSTRING(VAR, POS, 1))>0 THEN
SET TOTAL = CONCAT(TOTAL,SUBSTRING(VAR, POS, 1));
END IF;
SET POS = POS + 1;
UNTIL POS > LENGTH(VAR) END REPEAT;

IF (TOTAL='INSERTAR') THEN
INSERT INTO SI.rango_facturas
SELECT *
FROM rangos A
WHERE A.Funcion='F';
END IF;

RETURN TOTAL;

END $$
DELIMITER ;