Have a good day for everyone !
Does anyone help for where clause with multiple value ,
I am try for case when in where clause but it doesn't work.
it could be write in another way in sql/400 ?
Here is my example statement .
SELECT item , code_product , location, datesale
FROM mylib/product
WHERE case when moth(current timestamp)=04 and then datesale between 20180101 and 20180331 else datesale between 20180401 and 20180630 end
would appreciated any advice . Thank you so much
tintin
Does anyone help for where clause with multiple value ,
I am try for case when in where clause but it doesn't work.
it could be write in another way in sql/400 ?
Here is my example statement .
SELECT item , code_product , location, datesale
FROM mylib/product
WHERE case when moth(current timestamp)=04 and then datesale between 20180101 and 20180331 else datesale between 20180401 and 20180630 end
would appreciated any advice . Thank you so much
tintin
Comment