I have a dataset that has 6 columns of values, and I want the maximum for each row ACROSS the columns. It seems that MAX(), SUM() etc work within the columns, but not across them.

Does anyone know of a way to MAX across columns, or a cunning SQL statement that would do the job using a temptable?

BTW, I cannot modify the database structure, so normalising the dataset is out the window.