Re: SP Limitation of Constants for Subscripts

Red If you are using 7.31 (maybe also 7.30), there is a substr() function you can use which functions just like a regular substr() function, and allows variables as its arguments. HTH Sujit Red Valsen <red_valsen@yahoo.com> on 11/16/99 01:18:09 PM Please respond to Red Valsen <red_valsen@yahoo.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: SP Limitation of Constants for Subscripts Is there a workaround for the idiotic syntactic prohibition against variables for subscripts in stored procedures? I need to parse a string that I get back from a cursor, but am stymied because of this limitation. My braindead approach would read the column into a character-type variable, then loop through the string, evaluating each index as required. Alas. Does Informix eat its own dog food? Any alternate solutions would be greatly appreciated.