Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help with SQL Maths Operators RE: Help with SQL Maths Operators

  • September 24, 2013 at 5:10 am

    #1652653

    In SQL, ^ is a bitwise exclusive OR. You'll be wanting the POWER function.

    SELECT POWER(2,3) -- 8

    SELECT POWER(5,2) -- 25

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass