Re: Query

Posted in 2000

Richard harnden — Wed, 01 Mar 2000 12:27:09 +0000 — source: Informix-list mailing list archive (1991-1998)

Why ? Can't do it in pure sql, you'll have to write a stored procedure. By report do you mean 4gl/ace ? You could always do it in there . >>> "Sarah Jessica" <sarah_jessica@hotmail.com> 02/29/00 08:57pm >>> Hi, I am having a field which I have to findout the middle values and select into the report. select ctype from type;ctype ----- Computer Monitor MotherBoard 15" Monitor Now I want the result like this ctype ----- p i r o I am running Informix 8.21 under that there is no substr,substring functions. Hope the group will solve the problem. Thanks Sarah ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com