Substitute Function

Dear Team,

I am using a substring function for one of my analysis as below:

Substitute([Name],"B2C","Safexpress") as [new_Name]. Here name is column name, i am searching for b2c and changing it to Safexpress. Now is there a way where in i can add multuiple subs function lets say same for creating safexpress then for some other fields.


Please suggest as it does not seem to work.

(1) Answer