Re: SELECT from the EVENTS table doesn't look right.

Paul, You are correct. the design of the SELECT * FROM EVENTS was intended to present only events for today (just like QUERY EVENTS). However, I agree that the design ought to be changed to reflect the SQL standard: that is, SELECT * FROM presents *all* records in that table, not just certain on

SELECT from the EVENTS table doesn't look right.

Hello, Can anyone explain the following results to me? tsm: TEST>select count(*) from events Unnamed[1] --- 117 tsm: TEST>select count(*) from events where '08/01/2000' < scheduled_st art Unnamed[1] --- 8507 It seems as if by narrowing down