Grasshopper had a nice idea in response to your post... I am pasting his workaround below....it works!!!

----------------------------------------

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members

Last Login: 6/17/2013 2:51 PM

Points:...

Thought someone may still be looking for a simple answer.... If the table has NULLs then the following simple fix will work....

Declare @min-2 INT

--assign minimum possible...

Isn't it as simple as below:

select

case when col1>= col2 and col1>=col3 and col1>=col4 then col1

when col2>= col1 and col2>=col3...