Re: splitting atoms

bradley hanson <bradleyhanson@sprintmail.com> wrote: :I need to split a character field into two parts.. could anyone give me :advice on the best way to go about this? I assume you want to do it in SQL. (In any of the common programming languages it would be to easy for the question to appear I assume.) The answer is RTFM, but a hint: select charcolumn[1,6], charcolumn[7,10] from .... If that's not what you want you might want to specify your problem a little better. PS.: Hopefully this is either to redesign a database you have found isn't well designed or you have some very spesific needs where you know for sure this is the right solution. Otherwise splitting atoms of an RDBMS isn't the best of ideas. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org