Hmmm. Well you might be able to work some magic if you know the length of the field it's supposed to be, then you could subtract the length of the Field and then pad with spaces.
If this is to be displayed in a web page, and I assume you're trying to line things up pretty, just put them in table <TD> cells. If it's output to the terminal window, then try using a "\t" character to tab to the next spot for columnar output. Daevid Vincent http://daevid.com > -----Original Message----- > From: Ooks Server [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 4:38 PM > To: [EMAIL PROTECTED] > Subject: concat() differences between mssql and mysql > > > I've run into a problem with the behavior of concat(). If I > have two fields, > char(10), and I do this: > > concat(field1,fields) > > With MSSQL I get both fields including trailing spaces. With > MYSql, I get > the two fields with the trailing spaces trimmed. Example: > > Field1 = "abc " > Field2 = "qwerty " > > MSSQL -> concat( field1, fields) -> "abc qwerty " > MYSQL -> concat( field1, fields) -> "abcqwerty" > > How do I get Mysql to behave like MSSQL does? I need it to > concatenate the > fields without stripping the trailing spaces. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]