In SQL, are there non-aggregate min / max operators

Question

Is there something like

select max(val,0)
from table

I'm NOT looking to find the maximum value of the entire table

There has to be an easier way than this right?

select case when val > 0 then val else 0 end
from table

EDIT: I'm using Microsoft SQL Server

Answer 1

Functions GREATEST and LEAST are not SQL standard but are in many RDBMSs (e.g., Postgresql). So

SELECT GREATEST(val, 0) FROM mytable;