Are you talking about display width? Use the RPAD function:
http://dev.mysql.com/doc/mysql/en/string-functions.html
mysql> SELECT RPAD('foo', 20, 'x') AS foo; +----------------------+ | foo | +----------------------+ | fooxxxxxxxxxxxxxxxxx | +----------------------+
____________________________________________________________ Eamon Daly
----- Original Message ----- From: "Marc Michalowski" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Friday, January 28, 2005 12:27 PM
Subject: Fixed with Fields
I was wondering if there is a way to create fixed width fields. Example: The field is set to 18 but data contained is 11. I need the length to remain 18. Is there anyway to do this? Thanks for your help.
-Marc
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]