Re: [Q] Dynamic substring in SPL

Leonid Belov <white@intek.spb.su> wrote in article <ADBIHjoesD@intek.spb.su>... > Hi all, > > I need to analyze and convert some CHAR data in the stored procedure > intended for intensive usage by many different applications. > SPL doesn't support dynamic substrings, for example > > LET character = string[i,i] > > SYSTEM statement very slow and expensive. > Is it possible to make such a thing by any other way - in SP? > > Leonid > > > Hi Leonid, I wrote a couple of simple procedures, which performs this task.One for substring and one for cllipping two strings together. I can email you the source code. You can derive your own special procedures. -- Zdeno Miklas SOFTEC spol. s r. o. e-mail: ash@softec.sk Kutuzovova 23 phone : 42-7-273805 ext.128 831 03 Bratislava fax : 42-7-272537 SLOVAKIA