NULL ( )
The system scalar function NULL allows you to set a column as null values. The syntax is:
For example, the following SQL statement inserts a row in the Room table with a NULL value for Capacity:
INSERT INTO Room VALUES (’Young Building’, 222, NULL(), ’Lab’)
NOTE: Sage 50 dataset does not allow you to perform inserts.