Transact SQL - Max value

[747576]

I have a table with rows containing columns of % values i.e pct1, pct2 etc. How do I find the max value from the different columns for each row, what is the function.

thanks in advance

 

[JarlH]

Try something like:

SELECT CASE WHEN pct1 > pct2 AND pct1 > pct3 THEN pct1
WHEN pct2 > pct3 THEN pct2
ELSE pct3 END
FROM sometable


Core ANSI SQL-2003 compliant. (I know nothing about Transact SQL.)