Find Greatest of all columns per row in SQL

See more:

SQL-Server

I have a table which has some numeric columns and i have to find the greatest value from all column per row.

currently i am using this

SELECT
   CASE
       WHEN Col1 >= Col2 AND Col1 >= Col3 THEN Col1
       WHEN Col2 >= Col1 AND Col2 >= Col3 THEN Col2
       WHEN Col3 >= Col1 AND Col3 >= Col2 THEN Col3
       ELSE  Col1
   END AS MaxVal

but every time when one more column added i need to change all cases.

Is there any continent way to achieve this. Any thing like "greatest" in Oracle

I am using SQL Server 2000.

Thanks
--Pankaj