Using REPLACE to replace multiple values in query result

[yoavyoavyoav]

Hi,

I'm running a query that displays a list of values. for example the result will be :

a
b
c
d


I would like to replace "a","b" and "c" with strings of my own. How is that possible ? Using the "Replace" function allowed me to change only one string.

Thanks.

[iburyak]

You can use case or nested replace.

select case when col in (a,b,c) then 'string here' else col end

or

select replace(replace(col, 'a', 'string here'), 'b', 'string here') ......

Good Luck.

[Samrat Gavale]

@ iburyak,
very helpful post.
Thank you so much!