Return Max Field

[theKeyper]

Hi Guys,

I need to compare multiple fields and return the field that has the max value for that row. e.g.

SELECT HIGHEST(largest_classroom, largest_bedroom, largest_livingroom) AS largest_room

(Similar to the MAX() function but horizontal instead of vertical)

Thanks,
Keyper

 

[theKeyper]

Found It!

GREATEST()

Thanks,
Keyper

The Key is more powerful than the Sword.