Good suggestion. Tried that earlier today. Got that "incompatible union" error (or some such thing).

Thanks though.

paul


>>I'm using a VFP 5 database (not SQL server data).
>>
>>I'd like to run a query that returns a concatenated string in a memo field.
>>
>>Example:
>>select addr1+CRLF+addr2+CRLF+addr3+CRLF+city+CRLF+state+CRLF+zip as combaddr from address
>>
>>Where combaddr is a memo field. Is there any way to do this?
>>
>>Thanks.
>>
>>paul
>I haven't tried it but
>

>CREATE CURSOR TEMP (combaddr M)
>
>SELECT combaddr from Temp ;
>   union ;
>SELECT addr1+CRLF+addr2+CRLF+addr3+CRLF+city+CRLF+state+CRLF+zip as combaddr ..
>
>

>
>Arnon