Hi,

I was able to execute the following in Management studio successfully but was unable to replicate the results when using BIDS.

Update dbo.mydatabase

Set stage = REPLACE(Stage,'Closed Won','Awarded')

I tried the table solution but was not able to achieve the desired results.