Sql query date problem

[fcccc]

Hello guys, I need some help.
I have a table with a date field and i have a problem when i want choose data between two dates, like for example: 15-05-08 and 01-07-08.
When i choose this date it can't find the data, if I choose date between 15-05-08 and 16-07-08 the data is appear.
My conclusion is that if I choose the first digit lower date (15-) is more less that upper date, then the result is ok.

[debasisdas]

Is the date stored as date or char ?

[fcccc]

Is the date stored as date or char ?

The type of data is char(26).(dd-mm-yy hh:mm:ss)

thank you for your answer

[ck9663]

Convert both to the same data type. Preferrably datetime...


-- CK