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/[EMAIL PROTECTED]
