Re: sql question(s)

> I need to select a range of number from a table and display them via html. > I've got everything working but the select. When I use: > select * from tableA where number >= X; I get those >= X . However when I > try to grab a range say >=X <=Y I get the entire table. I am sure there's > just a simple error here but I cannot figure it out. So, this doesn't work: SELECT * from tableA where (number >= X && number <=Y) doesn't do what you want? -jeremy brand _______________________________________________________________________ GnuPG Fingerprint: 9F5E 95E0 1CC2 E054 84EA 6099 8ACD 9DBA D2C0 5EA9 _ http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more __