SQL Help Maybe?? Or ASP??

  • Thread starter Thread starter Bamarama007
  • Start date Start date
B

Bamarama007

First, I am using FP 2002, Access DB with SQL ...
Is there a way to use SQL or ASP to get the results to display every other line
in a DB table? Like show ODD numbered ID's or show Even numbered ID's ??
Like, if I have 100 entrys into my DB, but only want the ODD ones or EVEN ones
to appear on my page. Can this be done?
Jeff
 
SELECT * FROM MyTable WHERE IdField Mod 2 = 0 (Even)
SELECT * FROM MyTable WHERE IdField Mod 2 > 0 (Odd)

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
The more I learn, the less I know.
 
Back
Top