>> Is there a function that compares two columns in a row and will

On 21 Sep 2004 08:41:16 -0700, Philip Mette wrote:

>Is there a function that compares two columns in a row and will return
>the highest of the two values? Something like:
>
>Acct Total_Dollars Collected Total_Dollars_Due
>11233 900.00 1000.00
>
>Declare @Value as money
>set @Value=GetHighest(Total_Dollars_Collected,TotalDollars_Due)
>Print @Value
>
>
>This function will return 1000.00 or the Total_dollars_Due??
>
>Is there such a creature???