Pardon my idiocy in posting that this command gave ugly output: select if(substring(username,1,8)='cctcpin-', lcase(trim(leading concat(substring_index(username,'-',1), '-') from username)), lcase(username)) as username, sec_to_time(sum(acctsessiontime)) as session from radacct where acctstarttime between '2001-04-21' and '2001-05-21' and acctstoptime group by username order by username; The problem wasn't the data, it was the column header. I added the 'as username' portion and it returned to a normal column width. I'll drag my noise back off the list now. MySQL was not the culprit. -- =============================================== Kip Turk phone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Code/Penguin Proponent West Central Net fax: 915.656.0071 =============================================== --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
