I am usually quite happy to criticise what I think are bad aspects of SQL Server (or other products), but in this case I am more inclined to say:

Which part of REPLACE don't you get then?