Just a suggestion but have you tried
Update abc
set history= Replace(convert(text,(history), '
', ' ')

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Thursday, October 24, 2002 5:00 AM
To: LazyDBA.com Discussion
Subject: replace function in ntext datatype


Hi Friends,

I have a table abc which has 2 cols. Some of the
records of these 2 cols have '
' in them.

I gave the command

Update abc
set education= Replace(education, '
', ' ')
this works fine

i have col named History which has ntext data type

i tried giving same update command

Update abc
set history= Replace(history, '
', ' ')

i am getting error

Server: Msg 8116, Level 16, State 1, Line 1
Argument data type ntext is invalid for argument 1 of
replace function.

how do i solve this.pls help me its very urgent
Waiting for reply
TIA
Adil



__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page