criteria to filter NOT NULL record

Hi all,

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


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

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

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)