SQL problems.. ">" and "<"
Posted on 2003-11-25
I am using Ms Access for this project.
I have this raw data in the table;
And this is SQL Statement.
SELECT * FROM PURCHASE WHERE DateA>'14/01/2003';
And guest what will come out?
if i change the sql statement to, startDate<'14/01/2003'; this is the data come out.
WHat is going on? I am loss... please help.
If my statement is like this,
The result should be,
thereshould be no result at all.
But that's not what i am getting... please point my error.