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/
MS Sql Server LazyDBA home page