Azure SQL basic bit manipulation?

Question

I would like to create a function in a dedicated Azure Synapse SQL pool that will need to shift bits right >>.
What functions/operators are available to do this?
RIGHT_SHIFT and >> don't work for me, and I can't find anything about any bit manipulation in Azure, only for SQL Server 2022 ...

edit: I realize now that I tagged the question wrong.

Answer 1

Hi @Gary K ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

As I understand your question, you want to understand RIGHT_SHIFT in Azure SQL database.

Please refer below where RIGHT_SHIFT example is shown:

SELECT RIGHT_SHIFT(12345, 5);  

The result is 385. If you convert 12345 to binary, you have 0011 0000 0011 1001. Shifting this to the right by 5 becomes 0001 1000 0001, which is 385 in decimal.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification