I don't suppose so. If there was one in ISQL there was no need to have it in
the standard UDF.

I'm just using UDF's for SUBSTR and TRIMming. I just use the standard UDF
library to keep the database compatible between OS's.

I substitute the StrLen function of the UDF for one using Ivan Prenosil's
procedure. You can check his site:

http://www.volny.cz/iprenosil/interbase/

He have a Stored Procedure than can be easily adapt to your needs.

Artur Anjos

----- Original Message -----
From: "STC" <stc-net@...>
To: <ib-support@yahoogroups.com>
Sent: Saturday, October 27, 2001 9:48 PM
Subject: Re: [ib-support] Substring function


> Is there a substring function in ISQL?
> ----- Original Message -----
> From: "Artur Anjos" <arsoft@...>
> To: <ib-support@yahoogroups.com>
> Sent: Saturday, October 27, 2001 2:44 PM
> Subject: Re: [ib-support] Substring function
>
>
> > There is a substring function in the standard UDF. Take a look at it.
> >
> > Declaration:
> >
> > DECLARE EXTERNAL FUNCTION SUBSTR CSTRING(80),SMALLINT,SMALLINT RETURNS
> > CSTRING(80) FREE_IT
> > ENTRY_POINT 'IB_UDF_substr' MODULE_NAME 'IB_UDF.DLL';
> >
> >
> >
> > Artur Anjos
> >
> > ----- Original Message -----
> > From: "STC" <stc-net@...>
> > To: <ib-support@yahoogroups.com>
> > Sent: Saturday, October 27, 2001 5:58 PM
> > Subject: [ib-support] Substring function
> >
> >
> > > Can anyone tell me if there is a Substring function in Firebird and if
> so
> > what is the syntax?
> > >
> > > What I have is two variable character fields. One exists in an old
> > database(Paradox) file, both are in the new Interbase table. I am
> migrating
> > the data from Paradox to Interbase, and that works great. What I need
to
> do
> > is add data to the new field, based on what is in the existing field.
> > >
> > > The one with data is called STATUS. The one to populate is called
> > BAL_RET. The data going into the BAL_RET field is based on the first 2
or
> 3
> > characters in the STATUS field. I can run it multiple times for the 2
or
> 3
> > different values in STATUS.
> > >
> > > This only has to be done once. After the data is migrated, the
software
> > stores the correct value.
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>