I have an unusual problem. I have an comma delimited data file I have inported into Interbase. There are several columns that have dates in them in the format YYYYMMDD.

Is there a way to convert them to a more traditional format like MMDDYYYY or even better split them into 3 seperate columns.

Thanks,

Ron Richardson


[Non-text portions of this message have been removed]