>We would like to maintain the CR/LF when we copy data from FoxPro Memo fields to SQL 2008. They seem to strip out by default. Is there a way to do this?
>
>Thanks,
>Larry
No, CRLF is not stripped out, just SSMS shows results that way in GRID. If you have Results to Text you will see CRLFs.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.