'&' operator in TSql

• RamG

  Right there with Babe

  Points: 767

  More actions

  January 28, 2011 at 2:26 am

  #232899

  Hi,

  While I’ am running the below query

  select 456 & 16

  I got the result as 0 .

  Could you please anyone explain me how the & operator is woking in the TSQL.

  Regards,

  Ram

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  January 28, 2011 at 2:35 am

  #1279578

  Hi

  There is the bitwise AND operator (&).

  http://sqlfool.com/2009/02/bitwise-operations/

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  January 28, 2011 at 2:39 am

  #1279581

  Also refer

  http://msdn.microsoft.com/en-us/library/ms174965.aspx

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  January 28, 2011 at 2:42 am

  #1279583

  As explained above , & is a bitwise AND operation.

  What are you expecting the result to be (and why ) ?

  ---

  
  Clear Sky SQL
  My Blog[/url]