[MSSQL2000] chr(13) problem when export to text files

[erickwidya]

for example a column with "erick [enter] widya" when exported it put 'widya' one row below 'erick' where it need to be in same row so when imported back otherwise it return error

is there a way?

my final effort is : using somekind Spesial Character to replace [Enter] whenever it saved into a table so it can fit in one row when exported and when read back just replace those Spesial Character with [Enter]

but i just need to be sure that there's no other way

thanks

[kaffenils]

Why not use the REPLACE function in SQL Server. Replace CHAR(10)+CHAR(13) (or was it CHAR(13)+CHAR(10)?) with a space.

[erickwidya]

thanks kaffenils

Replace CHAR(10)+CHAR(13) (or was it CHAR(13)+CHAR(10)?)

i think the 2nd one is correct Carriage Return is CHAR(13) + Line Feed is CHAR(10)

well if i'm using space when is imported it would be using Space while i'm trying to used its original format..
guess have to try those 'spesial character' instead..

thanks