SQLite has MIN and MAX which find the highest/lowest value of a column,
but there seems to be no equivilent to what Oracle has as GREATEST/LEAST which find the highest/lowest value of two (or more) values
this would be the same as the Xojo syntax for Min/Max
SELECT a.field1, GREATEST(1,a.field2) as xyz FROM myTable
this would return 1 as xyz if the value of FIELD2 was <1
I need to do some stats on a table, where 0 and negative values are evaluated as 1