Re: Funcion INSTR

[Fabio Castillo]

ok, Thanks, now I understand.

I thought it was, but NO :(

The example we saw is the next and confused me

SELECT INSTR ( 'PEPE PEREZ', 'PE', 1,2) FROM DUAL;
Returns 3

But you're right, 3 refers to the position

I had done was create my own function to read the string and check for each record.

CREATE FUNCTION instrcount( cadena VARCHAR(20), SearchMyChar CHAR(1) ) RETURNS int
BEGIN
DECLARE cadenaLength int;
DECLARE posicion int;
DECLARE contador int;

SET contador = 0;
SET posicion = 1;
SET cadenaLength = LENGTH(cadena);

WHILE (posicion <= cadenaLength)
BEGIN
IF (SUBSTRING(cadena, posicion, 1) = SearchMyChar)
SET contador = contador + 1;
SET posicion = posicion + 1;
END

RETURN contador;

END

Thank you very much!