0

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
3
Views
5 Years
Discussion Span
Last Post by babyDBA
0

You can try this code

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.