Access Max Values from Query

[Big TR]

So I've got a query pulling values from a table, A=$100, B=$90, C=$105 for various projects.

What is the best way to pull out the maximum value for each data row in my table. In this example, I would want the query to show value C=$105. I will then need to pull this value into a report.

I'm having no luck.

[StevieG]

select MAX(column) from table

oh, wait, you have several fields and you want the max for each row?

In MySQL, you can use the GREATEST comparison

select GREATEST(A, B, C) from table