REPLACE Function in SQL Server

REPLACE()

Returns a string with all the instances of a substring replaced by another substring.

Syntax
REPLACE(find, replace, string)Find

Specifies the string that contains the substring to replace all instances of with another.

Replace
Specifies the substring to locate.

String
Specifies the substring with which to replace the located substring.

Example :
SELECT REPLACE('The Project is going to ?.','?', 'implement in Dotnet Technologies')
 

OutPut:
The Project is going to implement in Dotnet Technologies.