A simple query

A

ALL

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?
 
J

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
 
A

ALL

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.

John Spencer said:
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?
Click to expand...
Click to expand...
 
Top