In this article we learn how we can use replace function in sql server.  


SELECT REPLACE('SQL.Tutorial', '.', ' ');


in above statement it replace .(dot) with space and result will be 

SQL Tutorial