Hi All,

I have to query a SQL table and return all the records based on the datetime field. Given 4 variables that represents starting year, month and ending year,month:

lnYrFrom = 2005
lnMthFrom = 1

lnYrTo = 2005
lnMthTo = 3

how can I write a SQL query that will returns all the records within the specified date range?

I appreciate any suggestions,
Daniel M.