SUMMARY (addendum): subscripts in stored procedures.

Many responses, only one solution, courtesy of >From: "John H. Frantz" <john@rl.is> unfortunately, in my 5.03 Informix, varchars havent been invented yet. ADDENDUM: HOWEVER, CHANGING "VARCHAR" TO "CHAR" IN ALL CASES WORKS IN MY VERSION! > >June Tong provided the following clever solution which is in the FAQ >(http://www.iiug.org/techinfo/faq): > >-- >-- Procedure: GetCharAt() >-- Get a character from a string at a specified position. >-- >DROP PROCEDURE GetCharAt; >CREATE PROCEDURE GetCharAt(str VARCHAR(255), pos INTEGER) > RETURNING VARCHAR(1);> DEFINE i INTEGER; > > IF pos > 1 THEN > FOR i = 2 TO pos > LET str = str[2,255]; > END FOR; > END IF > RETURN str[1,1]; >END PROCEDURE; > >---------------------------------------------------------------------- >John H. Frantz Power-4gl: Extending Informix-4gl >john@rl.is http://www.rl.is/~john/pow4gl.html > >