A simple query

[Guest]

Would this query return values in a column if the field has a null entry?

Select pick_column_name
IffNot([pick_column_name] = "Null")

will this work?

 

[John Spencer]

As far as I know, it will not work.

Perhaps what you mean is


SELECT Pick_Column_Name
FROM SomeTable
WHERE Pick_Column_Name is Not Null

You should try to write in English what you expect the query to do and the
results you expect to see.

You might also have meant

Select IIF(Pick_Column_name is Null, "Null", Pick_Column_name) as columnValue
FROM SomeTable

 

[Guest]

John,

Thank you for your help. What I was trying to do was to write a simple
query to return a record if a column has a Null value.

As far as I know, it will not work.

Perhaps what you mean is


SELECT Pick_Column_Name
FROM SomeTable
WHERE Pick_Column_Name is Not Null

You should try to write in English what you expect the query to do and the
results you expect to see.

You might also have meant

Select IIF(Pick_Column_name is Null, "Null", Pick_Column_name) as columnValue
FROM SomeTable

Would this query return values in a column if the field has a null entry?

Select pick_column_name
IffNot([pick_column_name] = "Null")

will this work?