>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