[ad_1]
select case
when color="Black"
then 'Green'
else
case
when color="White"
then 'Red'
else color
end
end as [Color]
from paint
[ad_2]
solved SQL statement to replace multiple values
[ad_1]
select case
when color="Black"
then 'Green'
else
case
when color="White"
then 'Red'
else color
end
end as [Color]
from paint
[ad_2]
solved SQL statement to replace multiple values