Returns the missing value marker (-2147483647) for non-character fields.

Syntax:

#MV

Examples:

The expression #MV is useful for resetting fields to missing (i.e. blank).

Also useful for selecting records with missing values in a field, as in PAY = #MV.