|
Posted by Hilarion on 10/14/22 11:26
> How do you determine if a Date field is blank. In my Sql statement I
> only want records who's date field is blank (i.e. checking for only open
> invoices where Date_Paid = '' ...still open ...it doesn't work when I use
> that syntax)
SELECT some_column, another_column
FROM some_table
WHERE date_field IS NULL
ORDER BY some_column, another_column
Hilarion
Navigation:
[Reply to this message]
|