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.

Expand|Select|Wrap|Line Numbers

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

or

Expand|Select|Wrap|Line Numbers

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

Good Luck.

Using REPLACE to replace multiple values in query result

re: Using REPLACE to replace multiple values in query result

/bytes/development

/bytes/it

/bytes/about