I am storing dates in the form "20030218" (as it seems that there is no DATE format for Tables). If I do "SELECT * FROM table ORDER BY datefield", my program just hangs (whether the date field is INTEGER or CHAR(20)), but it works OK if I store my dates in the form "date20030218"; in other words, numbers won't sort unless I precede them with text. I also tried putting the numbers in doublequotes, but that did not help. Is there something I should be doing to make my numbers sort?
Clive F
