Member Avatar for amishraa

Is there a workaround to this as decode does not seem to allow the use of greater than equal sign
I am trying to show the comment for any days beyond 4 days, not just 4 days.

decode(shipdate-orderdate,'4','This is unsatisfactory!') comments
from orders

Thanks in advance!
:)

  • 3 Contributors
  • 2 Replies
  • 158 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by babyDBA
Member Avatar for hfx642

Consider...

Select Order_Number
From Orders
Where ShipDate - OrderDate >= 4;
Member Avatar for babyDBA

You can try this code

select (case when shipdate-orderdated>=4 then 'Unsatisfactory!' else 'Satisfactory!' end)
from orders

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.