Hi Dean,

You can try somethinh like this

select * from TABLE_NAME where DATE_FIELD > '2002-11-24 00:00:00.000' and month(logtimein)=11

Cheers!!!
Vijay G

 Dean <spinout@i...> wrote:Hi There

I'm wondering if anyone knows a way that would allow me to select all the 
data from the database where a field is equal to a certain value and all 
the values below it.

I have a Date column in my database, when I feed the SELECT statement the 
current day's date I want it to be able to select the events for that date 
and every other date that proceed's it for the rest of the month but NOT 
any of the events that has already passed (events prior to the current 
day's date).

The BETWEEN clause of the SELECT statement would be good for this is I was 
able to get it to somehow understand the last day of the month as I could 
write a statement that SELECTS all dates WHERE the date is BETWEEN 
DateToday AND LastDateOfMonth.

Is something like that possible?? If so could somebody possibly give me 
some advice regarding as to how I could achieve this. Any help is greatly 
appreciated.

Many Thanks.

Regards,
Dean.


---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now