How do you return the max of a column (Text field)?

Question

I can not find a way to execute the following simple query:

SELECT max(@SomeCol) FROM test_table;

I can do just about everything else except for that, max doesn't return what I expect.

Answer 1

You may be able to workaround the issue by loading the dB query/table into a .Net DataTable and use it's Compute method:

DataTable.Compute("AggregateFunction(DataColumn)", "condition|Nothing|null")