Hello Everyone. I would like to replace certain values from a field called [ReportVersion] with the values from another field called [Mode]. Not all of the values in the [ReportVersion] field need to be replaced. Both fields are in the same table. Can someone please help with this?
Example: the [ReportVersion] field has the following values: Call, SMS/TEXT, Instant Messaging/Email. I would like to replace all SMS/TEXT and Instant Messaging/Email values, with the value that is in the Mode field. The mode field will tell me if the value should be SMS, TEXT, EMAIL, or IM.