>Should not occur problems when retrieving reports.
>Note that you will need additional trnasformations from Date type to char(8) and you will possibly need additional coding for date verification.
>:) nice idea... we do not do it this way... but will think about such approach :)
Why wouldn't this be just DTOC(dDateVar,1) ?
It won't even need an extra column; just in the index.