• Almost:

    DECLARE @a BIGINT

    , @b-2 BIGINT

    SET @a = 16

    SELECT SQRT(POWER(@a,@a) - 17)

    and this will give an overflow error.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]