Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Field has two values- want to display both in SQL
use decode or the case contruct to display the different values ...
select case when p2.price_if_ = 70 then "Price RRP"
when p2.price_if_ = 2588 "Price WHL"
else 0
end price
from <table > where ...
-- Posted via http://dbforums.comReceived on Thu Nov 06 2003 - 02:48:35 CST