What is the result of 4 & 0x08000000

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 1

Hi There,

As far as I understand:

& Performs a bitwise logical AND operation between two integer values.

0x08000000 is a VARBINARY value for an integer in this case 134217728

SELECT 4 & 0x08000000,

CAST (0x08000000 as INT)

so you doing a bitwise logical AND between 4 and 134217728

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 2

Hi There,

Sorry I just saw that you edited your post.

Are you still looking for an explination?

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

sanuj SSC-Addicted Points: 438 More actions · Answer 3

Thanks Chris.. thank you very much...

This gives lot of clues ....:)