I'm searching for a way to place an aggregate function in the filter expression of the datatable's select method.

I thought the syntax would be something like

dim strexp as string
strexp = "MAX(columnName)"
foundrows as datarow()
foundrows = ds.tablename.select(strexp)

The error message indicates the filter expression 'MAX(columnName)' cannot be evaluated to a boolean expression.

Are aggregate expressions supported in the the select method? I searched the online docs without success.