Mensaje
De
16/03/2010 07:00:21
a
16/03/2010 06:43:38
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
ID de la conversación:
01454718
ID del mensaje:
01454719
Views:
43
Try REPLACE(REPLACE(yourfield, CHR(10), ''), CHR(13), '')
>Hi All, I imported some fox data to Sql Server recently and have noticed some weird looking characters in some of the memo fields - I think they are probably carriage returns / line feeds - any ideas as to how I can get rid of them ?
>Hi All, I imported some fox data to Sql Server recently and have noticed some weird looking characters in some of the memo fields - I think they are probably carriage returns / line feeds - any ideas as to how I can get rid of them ?
Regards N Mc Donald