Any (open)

Get 'a' value from a group

Syntax

// Core function, no LOADLIB necessary

VARIANT FUNCTION Any(VARIANT data)

Parameters

VARIANT data

Array of values

Return value

VARIANT

Returns any of the values in the array

Description

Any selects a value from a group of values. It is not specified which item. This function is useful if you need a value from a group but cannot use that value as a GROUP BY expression.