Your SQL command was:
SELECT TOP 10 objid,ra,dec,
flags,
flags & 0x00000000FFFFFFFF AS flags_lo,
(flags/power(cast(2 as bigint),32)) & 0x00000000FFFFFFFF AS flags_hi
FROM PhotoObj
Your query output (max 500,000 rows):
objid | ra | dec | flags | flags_lo | flags_hi |
1237678537421425088 | 319.791917548324 | 20.2061957760232 | 105622137733464 | 301990232 | 24592 |
1237678537421555647 | 319.792169723731 | 20.5006775753794 | 105622137733464 | 301990232 | 24592 |
1237678537406481020 | 319.794743644862 | -13.9811042954189 | 105622137733464 | 301990232 | 24592 |
1237678537404383705 | 319.798116444578 | -18.7570830830873 | 105622137733464 | 301990232 | 24592 |
1237678537418539867 | 319.798469985831 | 13.6267347927771 | 105622137733464 | 301990232 | 24592 |
1237678537420704235 | 319.801393363713 | 18.5443150340339 | 105622137733464 | 301990232 | 24592 |
1237678537416443206 | 319.801924466835 | 8.83314018106091 | 105622137733464 | 301990232 | 24592 |
1237678537418671511 | 319.802355306755 | 13.8889476056492 | 105622137733464 | 301990232 | 24592 |
1237678537421030038 | 319.803362966037 | 19.2440488569153 | 105622137733464 | 301990232 | 24592 |
1237678537420114088 | 319.803420255485 | 17.2848080442242 | 105622137733464 | 301990232 | 24592 |