Skip to Content
0
Feb 03, 2023 at 05:04 AM

SAP B1 Query (Retrieve IS NULL Value in Case When within Where )

352 Views

Dear Sir/Madam,

I would Like to Retrieve

"Indicator" is Null value From OJDT

using Variables Syntax are as following,

T."Indicator" From OJDT T Where Case When [%0] = '' Then T."Indicator" is Null and T."Indicator" = '' Else T."Indicator" = [%0] End

using = '' or = Null didn't get me the desired value.

Thanks,