Re: Please can you tell me what function get a piece of text from an

Posted in 1996

Jorge Torralba — Thu, 22 Feb 96 16:56:55 -0500 — source: Informix-list mailing list archive (1991-1998)

I really don't understand the question the way you presented it. I will only guess that you are trying to extract a portion of text from a column. maybe this will help. SELECT col1[3,5] FROM table This will extract the third thru fifth character from col1. of course you can specify other positions. Good luck, Jorge Torralba