• Login

DataSoft Corporation

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
   Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service

Copyright © 2020 DataSoft Corporation All rights reserved.