I need help from someone more experience then me.

I want to create a function on edb that receive a string as parameter and
return the reverse string.

Thanks in advance
Sorin

Sorin,

CREATE FUNCTION "ReverseStr" (IN "St" VARCHAR COLLATE ANSI)
RETURNS VARCHAR COLLATE ANSI
BEGIN
 DECLARE S VARCHAR DEFAULT NULL;
 DECLARE I, N INTEGER;

 IF St IS NOT NULL THEN
   SET S = '' ;
   SET N = LENGTH(St) ;
   SET I = N ;
   WHILE I > 0 DO
     SET S = S + SUBSTRING(St,I,1) ;
     SET I = I - 1;
   END WHILE;
 END IF;
 RETURN S;
END

--
Fernando Dias
[Team Elevate]

Thanks a lot

Sorin

þþý"Fernando Dias" ýþ ëúá áäåãòä
news:CD6040D6-B840-4BEB-B022-290CE3EDC4DA@news.elevatesoft.com...

Sorin,

CREATE FUNCTION "ReverseStr" (IN "St" VARCHAR COLLATE ANSI)
RETURNS VARCHAR COLLATE ANSI
BEGIN
 DECLARE S VARCHAR DEFAULT NULL;
 DECLARE I, N INTEGER;

 IF St IS NOT NULL THEN
   SET S = '' ;
   SET N = LENGTH(St) ;
   SET I = N ;
   WHILE I > 0 DO
     SET S = S + SUBSTRING(St,I,1) ;
     SET I = I - 1;
   END WHILE;
 END IF;
 RETURN S;
END

--
Fernando Dias
[Team Elevate]