Replace the string in Column

column value for
rbkamal.blogspot.com

like
rbkamal(dot)blogspot(dot)com

I) select web_address from personal_details where web_address  like '%com'

II)Select Replace(T.web_address, '.', '(dot)') As web_address  From  personal_details T

III)update  personal_details set web_address = Replace(web_address, '.', '(dot)') where web_address like '%com'