concatenate Access memo fields?

I have an ASP that displays two MS Access memo fields in separate table
cells just fine. However when I concatenate them with SQL as in "select fld1
& fld2 as temp...." to display them in one cell only part of the first field
is displayed in the table. What is causing this?

thanks
LJB

Re: concatenate Access memo fields?

LJB wrote:
> I have an ASP that displays two MS Access memo fields in separate
> table cells just fine. However when I concatenate them with SQL as in
> "select fld1 & fld2 as temp...." to display them in one cell only
> part of the first field is displayed in the table. What is causing
> this?
>
Concatenating in the query requires the query engine to coerce the
operands to Text, which causes the truncation. You will notice that this
occurs if you create and run a query that does this concatenation in
Access Query builder.

Do the "concatenation" when writing the data to response (use two
separate response.writes, one for each memo field)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: concatenate Access memo fields?

"Bob Barrows [MVP]" wrote in message
news:u7rEaCUfHHA.2640@TK2MSFTNGP06.phx.gbl...
> LJB wrote:
>> I have an ASP that displays two MS Access memo fields in separate
>> table cells just fine. However when I concatenate them with SQL as in
>> "select fld1 & fld2 as temp...." to display them in one cell only
>> part of the first field is displayed in the table. What is causing
>> this?
>>
> Concatenating in the query requires the query engine to coerce the
> operands to Text, which causes the truncation. You will notice that this
> occurs if you create and run a query that does this concatenation in
> Access Query builder.
>
> Do the "concatenation" when writing the data to response (use two
> separate response.writes, one for each memo field)
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
Problem solved.
Thank you.
LJB