At 13:11 -0700 7/8/03, Daevid Vincent wrote:
>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.
Another option, depending on the application, might be to use
>> -----Original Message-----
>> From: Ooks Server [mailto:OoksServer@stripped]
>> Sent: Monday, July 07, 2003 4:38 PM
>> To: mysql@stripped
>> 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:
>> 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.
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/