Need help with a SQL Select statement. I've got a table that consists of a
list of years (1930-2014). I need to create a drop-down list on my page that consists of a list of years between 1930 and the current year. How do I construct this SELECT? See below... SELECT * FROM table WHERE 'year-field' <= year of current date What's the syntax for "year of current date"? Thanx in advance for your help, Robb Kerr Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams ---------------------------------------------------------------- http://www.digitaliguana.com <http://www.digitaliguana.com/> http://www.cancerreallysucks.org <http://www.cancerreallysucks.org/>