On 23 Apr 2002 at 11:15, Helen Borrie wrote:

> At 12:25 PM 23-04-02 +1200, Sandeep wrote:
> >Where can I get the list of all functions in firebird?
>
> In the release notes. You should read them, as select first has some
> undesirable (nay, catastrophic) effects if you use it thoughtlessly with
> DELETE...
>
>
> >Why doesn't
> > select substring (fieldA from 0 for 2) from tableA
> >work? I get exception [Positive value expected]
>
> Because the dataset doesn't have a "row 0". It will either have no rows or
> it will have one or more. Positive means "non-zero and non-negative".
> fieldA from 1 for 2 will capture the first two rows.

Rows? I think you've overlooked function SUBSTRING.
Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz