Results 1 to 2 of 2

Thread: where field & value = value

  1. 04-04-2013, 12:57 AM #1
    Gretel
    Gretel is offline Registered User
    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
    Reply With Quote Reply With Quote
  2. 04-09-2013, 06:36 PM #2
    skhanal
    skhanal is offline Experts
    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
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules