Subject Re: [firebird-support] Re: Returning Partial field Value
Author Helen Borrie
At 10:30 AM 31/08/2003 +0000, you wrote:
>Hi Aage,
>
>--- In firebird-support@yahoogroups.com, Aage Johansen wrote:
> > This is covered in the manual (at least for Fb1.5):
> > ----------------
> > SUBSTRING( )
> > Returns a string of specified length from within an input string,
>[...]
>
>This is not in FB1.5rc4, I assume?

Yes, it's in all Firebird versions from late betas for Rls 1.0 onward.
See either set of rlsnotes for syntax - the language additions from rls 1
are republished in the 1.5 notes.
Ex.
select substring(registration from 1 for 3) from aircraft

heLen