please check and confirm me.

>===== Original Message From <[EMAIL PROTECTED]> =====
>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


Reply via email to