Comparing Multiple Fields for Highest Value

Good afternoon,
Does anyone have a crafty way to compare  multiple numeric fields (More than 2, I would otherwise use the @MAX function) in a database. I would like to take the highest numeric value and then do some testing on that... Thanks for any insight!