isnotempty()

Returns true if the argument isn't an empty string, and it isn't null.

Deprecated aliases: notempty()

Syntax

isnotempty(value)

Parameters

Name Type Required Description
value scalar The value to check if not empty or null.

Returns

true if value is not null and false otherwise.

Example

Find the storm events for which there's a begin location.

StormEvents
| where isnotempty(BeginLat) and isnotempty(BeginLon)