NULL ( )

Sets a column as NULL values.

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.

Thursday, 18 April 2019 Posted in Logical Functions