Hi,

I have a PROCEDURE where I have to use a TEXT variable (REFERENCES).
How can I return a piece of this column? (for example one line).

CREATE PROCEDURE myproc() RETURNING CHAR(10);
DEFINE
tr REFERENCES TEXT; -- tekst file

SELECT col
INTO tr
FROM tab
WHERE id=1;

RETURN tr[1,10]; -- how can I do it?
END PROCEDURE

Thanks,
Adam