Hi Ron

Can you tell us what version of IB / FB you are using now? You can use some
of the text functions that are available in the UDF library for this - check
the manual for SUBSTR in the IB_UDF library - but you don't need the UDF if
you are using FB RC2, since it already have a substr function.

I think the best way to do it it's to create another field in the table, and
use a Store Procedure that will work with SubStr function and some
concatenation. You can use CAST also and get a DATE field in a go.

Artur

----- Original Message -----
From: "AdPay-Systech"
To: <ib-support@yahoogroups.com>
Sent: Thursday, March 07, 2002 8:14 PM
Subject: [ib-support] Text Functions


> 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
>