Re: Substring does not work

You could use the substr(string, start, end) function. At least in 7.3x Best Regards, Octav Thomas Hahn wrote: > > This is a multi-part message in MIME format. > --------------F85020B873CADEE5BBAC45D4 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Using a fixed substring on a variable (or database field) works fine > (i.e. v_stringvar[1]). > Using a variable for the character position (v_stringvar[v_integervar]) > causes an error in informix sql. > Is there any solution for this problem? > > Thank you, > Thomas > > --------------F85020B873CADEE5BBAC45D4 > Content-Type: text/x-vcard; charset=us-ascii; > name="T.Hahn.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Thomas Hahn > Content-Disposition: attachment; > filename="T.Hahn.vcf" > > begin:vcard > n:Hahn;Thomas > tel;work:+49 711 821 40367 > x-mozilla-html:FALSE > org:Alcatel SEL AG;MSE > adr:;;;Stuttgart;;;Germany > version:2.1 > email;internet:T.Hahn@alcatel.de > fn:Thomas Hahn > end:vcard > > --------------F85020B873CADEE5BBAC45D4-- -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com