From: Gerald L. Clark Date: January 15 2001 4:39pm Subject: Re: display width in mysqlgui List-Archive: http://lists.mysql.com/mysql/61790 Message-Id: <3A6327B3.D6350E7D@suppliersystems.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Rick Pasotto wrote: > > SELECT concat(last_name,", ",first_name) as name from members > > results in a column that is much wider than necessary. Adding trim() to > the concat() nor to the components makes any difference. > > Can the column width be specified? > > -- It doesn't for me. What table type, and field types are you using?