Find maximum of two fields and then report that value to antoher

[PRANerd]

I need to update a field in a table called "results" with the maximum number from one of two fields (say, "RAW and RAW_RG") in another table called "calcualtio n".

The data in the "calcualtio n" table is generated by a different software product.

My ultimate goal, is that i may run the calcualtion repeatedly, and each time I want to determine the max value for each entry in table and then createa a new table which only contains the maximum result.

thanks

[mcupito]

So the Maximum number to be returned can come from either "RAW" or "RAW_RG" ? And those are two separate fields in a database?