LENGTH function and trailing spaces

> > > 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 select collength from syscolumns, systables where colname = 'xxxxx' and tabname = 'yyyyyy' and systables.tabid=syscolumns.tabid j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "I wave my private parts at your aunties. I burst my pimples at you, you tiny empty headed wiper of other peoples bottoms." -MP&THG- French Taunter II _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________