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 f
003 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
; To: [EMAIL PROTECTED]
> Subject: Re: concat() differences between mssql and mysql
>
>
> "Ooks Server" <[EMAIL PROTECTED]> wrote:
> > I've run into a problem with the behavior of concat(). If I
> have two fields,
> > char(10), and I do this:
> >
> &
"Ooks Server" <[EMAIL PROTECTED]> wrote:
> 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 trim
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
