search and replace charecters in the SQL server query : I have a long sql query and have to modify the query by doing a search and replace for the below strings found. Can you pls. let me know the easiest way to achieve it.
1) Search and replace the 
input string -  "ch.[No_] AS [Contract No.]"
as
output string - "ch.[No] AS [ContractNo.]"
2)
input string -  [Status Reason Code Description]
output string - [StatusReasonCodeDescription]

This search and replace has to scan the whole query and replace only if the above string is found, so that this modified query could be runned in an other DB
