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: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:
>
> 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?> unsub=daevid@stripped
>
