I found It !!!!
it was like this:
WHERE MyStupidTable.Work_date <= to_date('15-DEC-00')
How simple was that?
Now it is just a matter of finding a function that will turn a regular date into that format: dd-ShortMonth-yy
thanks
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson