Professional Web Applications Themes

Querying....how can I write this? - Microsoft SQL / MS SQL Server

I have a column with binary value (bit mask) 0x020000000000000000000000000000 I want to select all data with bit sets to 1. how can I write this in a WHERE statement? Thx -- == fabriZio...

  1. #1

    Default Querying....how can I write this?

    I have a column with binary value (bit mask)

    0x020000000000000000000000000000

    I want to select all data with bit sets to 1.

    how can I write this in a WHERE statement?


    Thx
    --
    ==
    fabriZio




    fabriZio Guest

  2. #2

    Default Re: Querying....how can I write this?

    Do you mean you want only rows where a specific bit is 1?

    You can use the bitwise AND to do this:

    CREATE TABLE SomeBin (bin VARBINARY(32) PRIMARY KEY)
    INSERT INTO SomeBin VALUES (0x020000000000000000000000000000)
    INSERT INTO SomeBin VALUES (0x020000000000000000000000000001)

    SELECT *
    FROM SomeBin
    WHERE bin & 1 = 1

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --


    David Guest

  3. #3

    Default Re: Querying....how can I write this?

    There is one big disadvantage to David's solution: you can only use
    integer values in the AND expression. This basically limits its use to
    63 bits (bigint).

    For bigger varbinaries (for example varbinary(32)), you would need to
    cut the binary in pieces using SUBSTRING.

    Hope this helps,
    Gert-Jan
    Gert-Jan Guest

Similar Threads

  1. Querying Blobs
    By Tulsa in forum Coldfusion Database Access
    Replies: 2
    Last Post: September 23rd, 05:28 PM
  2. Querying a timestamp
    By trendline in forum Coldfusion Database Access
    Replies: 4
    Last Post: March 9th, 08:57 PM
  3. Querying a Db Using a List Box
    By jasonslipp in forum Macromedia ColdFusion
    Replies: 4
    Last Post: February 28th, 09:29 PM
  4. Replies: 2
    Last Post: June 1st, 08:38 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139