Results 1 to 2 of 2

Thread: where field & value = value

  1. #1
    Join Date
    Apr 2013
    Posts
    1

    where field & value = value

    Can anyone explain in plain english what this clause translates to:
    select * from Table123 where Field123 & 524288 = 524288

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    This is doing bitwise AND operation between the value of the Field123 and 524288. So WHERE clause will be true if Field123 value is 524288

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •