Re: STORED PROCEDURE problem-strings

palkoci@feld.cvut.cs (Milos Palkoci FIDO ) writes: >Hi everybody, >I have got the following problem in SPL : >I have declared some string (for. ex char(200) ), >and I want to reference to certain characters of the string ( like >for instance ss[45] in normal C-language). >I do not know how to do it in SPL. >Does anybody have any idea ? This is a fairly serious shortcoming in SPL; no subreferencing. The first thing I ever tried in SPL was create a soundex function, and this limitation stopped me short. There's a feature request to add this to a future version (I know it's not a good answer, but I thought I'd mention it). I gave up; but on thinking about it now you might try inserting the string in a TEMP table and then fetching the substring from it, since I believe SELECT ss[45] FROM table is valid syntax. Yours in not-a-great-answer-but-at-least-an-answer, ============================================================ Dennis J. Pimple Informix Software Inc Senior Consultant Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025