How to string Replace in Sql server

Question

Table Designing:

 

TempId    TempName    Message

 

1                Fees             Dear * your * is pending amount

 

Front end selected value in "*" D

 

How to this text in "*" only get it different value replace the data.

 

I want This result :

 

Dear John your 25000 is started pending amount