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