SQL help

[Tailgun]

I have a form with an Adodc control and a DataGrid.
If I setup the Adodc for SELECT * FROM tbClaim it lists all the records so I know it works but I need this WHERE statement

SELECT * FROM tblClaim WHERE AppraiserLastName IS NOT NULL AND DateClosed = NULL

When I use the above it returns no records although there are many records that meet the criteria so something is wrong with the statement. I get no errors at all just no records

Any help would be appreciated.

 

[cj44]

You can't use = NULL, you have to use IS NULL.
I would rewrite your query as:

SELECT * FROM tblClaim WHERE NOT (AppraiserLastName IS NULL) AND DateClosed IS NULL

Hope that helps.

 

[lovell811]

try:
Where AppraiserLastName <> NULL AND DateClosed = NULL

Joe

 

[Tailgun]

Thanks cj44 worked like a charm

Thanks again