Find Greatest/Least Value

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

Nevermind… It seems that in SQLite, there are TWO versions of MIN/MAX one for columns, and one for values