• Just as a note, you don't have to use ABS to get the positive value for a negative, use

    declare @i int

    select @i = -5

    select -@i