Replace function with 2 conditions

[#1]

Hi All,

I have a simple query. When using the replace function in the script.

eg. replace(StoreName,'Store','') as StoreName

Above replaces all StoreNames with the name 'Store' with a blank.

What if i need to replace multiple text values. eg. Store and Shop how would i go about it?

I have tried replace(StoreName,'Store','Shop','') as StoreName

                 replace(StoreName,('Store','Shop'),'') as StoreName

Any ideas or solutions?

Regards,

Richard

[#2 · Accepted solution]

Sorry found another way around it =  replace(replace())