Solved: Syntax for SQL lookup column that is NULL?

Hi All,

I have a combobox that points to an on prem sql database table and I need to, as part of the lookup filter where the column = NULL.

What is the syntax? I've tried the following:

column = "Null"
column = "NULL"
column = null (gives error)
column = Blank()

Edit to clarify, what i'm fully trying to do is have comboboxes to filter down some choices in a lookup table in SQL. So the first combobox shows the type options, from there based on what they select the next combobox should now show me a list of make of that type. However some of them are null and if that is the case i want to hide the combobox and just have an open text field to type in.

The combobox visibility is what i'm trying to do, i want it to show if the first combobox selected does not have a null value for the 'make' column, otherwise hide this combobox:

Visibility = 

If(IsBlank(LookUp(Inv_Equipment_Type, EquipmentTypeID = First(Filter(Inv_Equipment_Type, EquipmentType = ComboBox1_1.Selected.Value)).EquipmentTypeID && Make = "Null")), false, true)

Essentially if there is no make to choose from hide it so i can give you the open text to type it in, otherwise show it so you can select from the make in the database.

Thanks.

Categories:

General Questions