SQL Select where problem

i have a query thats supposed to select data from an access 97 database

$Query = "SELECT * FROM table WHERE created >= '$from' AND created <= '$to'";

the created field is a text field and has dates stored like 22/08/2003

when i run the query it just lists everything

however if i just pass a variable like

"SELECT * FROM table WHERE created = '19/08/2003'";

it works and lists everything created on that date

however as soon as i add a > sign to that query eg

"SELECT * FROM credit WHERE created >= '19/08/2003'";

it just bloody lists everything again

what am i doing wrong....?????

dates should be stored in a table as follows
YYMMDD

since when your comparing a date with another you first need to consider the year,month then the day!

kind regards
paul

You should store your dates in a date or date/time type field, then this would work.

Please note that if you are in MySQL 4.0 and above, or any flavor of postgresql from the last few years, you can cast the fields:

select * from sometable where cast(datefield as date) >= '2003-05-04';

kinda of thing