>>Hi,
>>
>>I am going crazy as to why the following give an error:
>>
>>
>>select * from mytable where case when mytable.order_no > 0 then 1=1 else 1=0 end
>>
>>
>>What is missing in the above?
>>
>>TIA
>
>
select * from mytable where mytable.order_no > 0
>
>PS: As with your previous query, you are going the wrong path, do not unnecessarily try to use case.
I agree I should have shown the real case. If you look at my reply to Sergey, you will see a little more of what I am trying to do. And maybe I should not be using the case. Hence I asked the question.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham