Обсуждение: replacing a word..

hi guys

I have to remove a entire word from a database column in a sql statement..

One of my database column contains strings like '###TOP_IMAGE###' ,
'###BOTTOM_IMAGE' , '###QUOTE###' and '###ACTIVITYBAR###'

This is later picked up by the rendering agent and the appropriate
HTML element is inserted in its place..

But i want to prohibit my full text indexer from seeing this text.

How can i replace all occurences of such strings with a zero length
string..

e.g
S ###TOP_IMAGE### pain's Davis Cup hero Juan Carlos Ferrero has withdrawn

should be seen by indexer as

Spain's Davis Cup hero Juan Carlos Ferrero has withdrawn


Is it possible.. I tried using translate() and the ~ operator to no
avail..

Could some please shed some light on this..

Thanx
Anand Raman