RE: LENGTH function and trailing spaces

Just look in a manual at the definition for syscolumns and it will give you the length of a char field. I just wrote a small 4gl to re-create an image of a table and had to do something similar. ===================================================================== Paul Watje Database Something or Another watjep@hasting.com Hastings Books, Music, & Video ---------- From: ilist To: informix-list Subject: LENGTH function and trailing spaces Date: Tuesday, April 04, 1995 9:14PM Length is documented as returning the length of a character column, not including the trailing spaces. What method do I use IN SQL to get the REAL length of character column? i.e. what size would be available to a program that fetched that column -- Kirk Bradley Oracle Corporation Mainframe and Integration Technologies Group