criteria to filter NOT NULL record

Business Central/NAV Technical Forum
1

Hi all,

To filter only NULL record, we use ‘’ (single quote). How about to filter NOT NULL record ?

2

HI,

Use <>’’ for filtering NOT NULL Record…!!!

3

Technically that’s not NULL it is ‘empty string’. NULL values don’t exist in NAV databases.

4

As Daniel already said, Navision SQL DB has NOT NULL constraint for every field in every table.

So ‘empty’ numeric fields contains 0, text fields - empty string, and date(-time) is a interesting one, it actually is 1735-01-01 00:00:00 in DB when seen empty in Navision client. Closing dates, seen as, for example, C31.12.2009 in Navision has time part as last second before midnight, 2009-12-31 23:59:59 in SQL DB.

This tricky contents of date fields is actual, when you access Navision DB directly by some T-SQL script. ? (Standart warning follows - use such scripts for SELECT only, never for INSERT / UPDATE / DELETE)