HI All,

Since I'm novice in sql-query's, plz help me for the below example....

I want to display ALL the records having starting time from now()
and
the records where the end date is specified and which is yet to come
is also included in the result
while
the records where the end date is specified and which is passed over
is excluded.

suppose for example dbase table contains below records

date enddate
18 aug 15 aug
10 aug 30 aug
1 aug 0000-00-00(default if user didnt specified end date)

Here for output on 18 aug, this is to be displayed,
10 aug 30 aug
1 aug 0000-00-00

plz help me with the Query for this result....
Thanks...