select UserAgent from bits where UserAgent &3 =4 I get nothing. How do I get just the chrome from bits table (00000111)? 00000001 = all 00000011 = opera 00000111 = chrome 00001111 = safari create table bits(UserAgent binary) insert into bits(userAgent) values (00000001) insert into bits(userAgent) values (00000011) insert into bits(userAgent) values (00000111) insert into bits(userAgent) values (00001111)
select UserAgent&4 from @bits where UserAgent&4=4
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)