How to test a bit in an integer?

  • Thread starter Thread starter Pierre Couderc
  • Start date Start date
P

Pierre Couderc

I want to test a bit in an integer and I have SQL command :
SELECT myfiels,int FROM table WHERE (( int & 1)=1);
I want to get all the the lines where int is even.
This instruction does not work in JET motor. I suppose that my syntax is
false somewhere.

What am I missing?

Thank you in advance.
Pierre Couderc
 
You can use the Mod operator for this...

SELECT * FROM SomeTable WHERE (SomeField Mod 2 = 0)=True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

BITs: string to int 4
Converting Text to a Integer, 3
SQL statment to convert integer to string 4
waveInOpen 64-bit 0
SQL Syntax Error??? 1
What's the data type for "long (64-bit integer)"? 3
a string to an integer 11
how to find all the partitions of any integer in four terms? 4

Back
Top