See ABS() function.
>In the statement below, this returns the correct value, which often is a negative number (almost always) which it should. But I want to bring it back as a positive value. Does SQL have a method to do that?
>
>
>
>cast(isnull(datediff(mi,meetings.PacuEnd,meetings.DischargeTime),0) as int) as DiffMinsPacuEnd_Dis
>
>
--sb--