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