select 12^21

• darth_vodka

  Default port

  Points: 1489

  More actions

  June 26, 2012 at 3:45 am

  #258464

  hi

  simple question, what does the ^ do in t-sql?

  it's eluding me on google

  thanks

  EDIT:

  aha, bitwise OR

  hmm

• rhythmk

  SSCertifiable

  Points: 7271

  More actions

  June 26, 2012 at 4:03 am

  #1505471

  darth_vodka (6/26/2012)

  ---

  hi

  simple question, what does the ^ do in t-sql?

  it's eluding me on google

  thanks

  EDIT:

  aha, bitwise OR

  hmm

  Hi darth_vodka,

  This is binary XOR.

  --rhythmk
  ------------------------------------------------------------------
  To post your question use below link
  
  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
  🙂

• Kumara1011

  SSC-Addicted

  Points: 424

  More actions

  June 26, 2012 at 4:47 am

  #1505485

  Hi,

  its ^ (Bitwise Exclusive OR)

  Here is the small example using that operator.

  CREATE TABLE bitwise

  (

  A int NOT NULL,

  B int NOT NULL

  )

  INSERT bitwise VALUES (170, 75)

  select * from bitwise

  SELECT A ^ B FROM bitwise

  --Returns 225