>>What happens if you SELECT that field that way:
>>
>>SELECT REPLACE(YourField, CHAR(13)+CHAR(10),'~~')
>> FROM YourTable
>>
>>Did you see any '~~' in the result?
>
>No, I don't see them :( Looks like they were not saved correctly?
>
>This is what I see
>
>First line Second line Third line Fifth Line
Hmm, and with this:
SELECT REPLACE(REPLACE(YourField, CHAR(13),'~'),CHAR(10), '#')
FROM YourTable(check the syntax, I didn'y :o))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
