Re: string manipulation in SPL

> > > A new topic for me. Any pointers? > > > > LET txt_strg = txt_strg || varaible4 > > > > I cannot seem to clip. I keep getting the full 255 characters in txt_strg > > which makes appending the second variable moot. I've considered writing a > > sub procedure, but if it always returns 255 characters, whats the point. I > > also don't seem to be able to subscript. TFM is of course a great help. > > That's because whoever designed the language didn't believe that a > clipped function is either necessary or desirable. Ok. Here's what I'm going to try. I need to do this as an SQL command. The situation is that I want to: INSERT INTO table (text_field) execute procedure xyz(var1, var2, var3); SO! CREATE PROCEDURE blah_blah_blah SYSTEM run_4gl_prog_which_does_work_and_inserts_into_table READ_from_table and RETURN. DROP TABLE. Where there's a will there's a relative. j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| He who talks most, talks least. jparker@hpbs3645.boi.hp.com | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________