I have two fields in a table with values defined as varchar that are
actually numbers for months and days. I need to collect the data with a
select statemet and sort by date.
My first attempt at sorting did not work because the leading zeros are
missing. I added leading zeros after collecting the data but it still
sorted incorrectly (ie 01, 20, 03) for first, twentieth and third.
The fields with the numbers for month and day numbers are ml_mna and
ml_dya. (in table ml_tidplats)
In my latest attempt I try to format the numbers into a date ...