Last post Feb 23, 2015 10:46 AM by mgebhard
Feb 23, 2015 10:33 AM|vj78|LINK
I have the below listed where clause with case statement it.
Now, it works if the checkboxes are checked but it does not display values when they are unchecked.
If they are unchecked I would like it to display all data.
PO.Part_Status <> (CASE WHEN @InActive = 'True' THEN 'InActive' END)
Unit_Price - SO.Price2 <> (CASE WHEN @Price = 'True' THEN '0' END)
Feb 23, 2015 10:46 AM|mgebhard|LINK
This might what you're after.
(PO.Part_Status <> 'InActive' OR @InActive = 'False')
(Unit_Price - SO.Price2 <> 0 OR @Price = 'False')