>Thank you.
>
>>See & operator
>>
>>>
>>>Is there an equivalent to BITTEST() function that works on SQL Server? For example, if I have the following expression in the SQL Select:
>>>

>>>select * from mytable where BITTEST( field_name, 1 )
>>>

>>>
>>>Thank you.

See this good blog on this topic by Michelle Ufford http://sqlfool.com/2009/02/bitwise-operations/
and make sure to also check blog post that Denis Gobo references in the comments (In fact, I started looking for Denis post, but found this good post by Michelle first).