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