RE: Best method using SQL to combine date fields (day, month, year)

guessing about file format here:
you did say it was in separate fields..

XCC X2 century 20
XYY X2 year 08
XMM X2 month 10
XDD X2 day 20

(sort format)
XCC||XYY||XMM||XDD gives you 20081020
or as you stated
XDD||XMM||XCC||XYY gives you 10202008

this can be used in select, order by, and Group
in SQL





The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public-records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing.