>i have a table named tb_account. inside this table i have all information about the account. i have four type of account. it cant be client,broker,carrier and propest. (its 4 different field). so an account can be one of them , or two of them etc... so if i want a select to retrieve all the client, broker account ??? how can i do that ?

What type are these fields? Logical?

If yes, then

select * from Tb_Account where Client = MyClient_Code and Broker = .T.

Or you want only accounts which are broker and no other types? If yes, then logical AND needs to be applied.

With integer fields 1/0 you would be able to use BITAND function.