I would think of using order by then, using top 1 to get the max value.

select top 1 given_field from your_table order by given_field desc

using case statement only makes sense...