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 lin
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
; 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
