how can i realise that, i think its not a good idea to save dates in
this format 20041030 (it means the year 2004, month 10 and 30th day)
to solve my problem---
Why do you think that? It is really simple to read, write & compare....
what's the matter?
for example i have many rows with each one date (everdy needs a row) from the
beginning of the year 2002 until 2004 and i will start a query where i will get all
rows
from july of the year 2002 until 2004.
SELEC * FROM mytable WHERE date > '20020701' AND date < '20041231'
Paolo