VBA: datatype variant

There are two variant literal identifiers: empty and null.

As long as a variant variable is unitizlied, it is said to be empty. isEmpty() can be used to determine if a variant was initialized.

A variant (as opposed to all other VBA data types) can be set to null to specificilly indicate the absence of any value or invalid data.

If the «value» of a variant is empty or null can be tested with the isEmpty() and isNull() function.

datatypes

C definition of a VARIANT

The SQL Server data type sql-variant.