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