General information
Category:
Coding, syntax & commands
But that means that I still have to fill in the field after the main query is run (combaddr could be 75-375 characters long).
I'll have to use a replace command.
Thanks.
paul
>Hi Paul
>
>You can't do it directly in a SELECT statment but you could do your select and then:
>
>ALTER TABLE ALTER combaddr M
>
>
>
>>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only