[QODBC-Desktop] Troubleshooting - How to select a record when the value is null
Posted by Jack - QODBC Support on 23 March 2015 01:43 PM
Troubleshooting - How to select a record when the value is null
I am trying to run a report that returns ItemInventory where LastReceived is NULL. I have tried in vain to accomplish this. What syntax do you use to select a blank/null date, or is there a special function for this?
You can select a blank/null date using "IS NULL" in your query.