concat() differences between mssql and mysql

[Ooks Server]

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.