Skip to Content
0
Jan 17, 2023 at 04:09 PM

Query for 0 value field

41 Views

Can someone give me the right formula?

I have a UDF field on OITM, called Std_Cost its for information purposes only its structure is Price

I am trying to query all items where the Std_Cost is 0 or null and I am not getting results.

SELECT T0."ItemCode", T0."U_AIS_STD_Cost" FROM OITM T0 WHERE T0."U_AIS_STD_Cost" =0

I just added the field and only have 1 item with a value, so I am expecting a lot of results.

Can someone give me the correct syntax on this?