Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL for EMPTY records
I am trying to open a recordset using the following SQL
statement: "SELECT * FROM MyTable WHERE MyDate = ''" I want all the records that don't have a valid date...in the database, there is either a date value or "N/A" to indicate that there is presently no date. Under normal conditions (i.e., selecting all the records in MyTable), all the records in the MyDate field that have "N/A" values are returned as empty strings. What is the proper SQL syntax for getting all the non- date values in the MyDate field? Thanks, Seth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
Extra/empty records in CSV file | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) |