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.