IsEmpty

Returns TRUE if the evaluated expression is the empty cell value, FALSE otherwise.

Syntax

IsEmpty(«Value Expression»)

Remarks

The IsEmpty function is the only way to reliably test for an empty cell, because the empty cell value has special meaning to Microsoft® SQL Server™ 2000 Analysis Services. For more information about empty cells, see the OLE DB documentation.

Example

The following example returns TRUE if Measures.CurrentMember is an empty cell:

IsEmpty(Measures.CurrentMember)

See Also

Working with Empty Cells