several links to documentation can be found in the Group Database
section ('links for new users' table).

www.ibphoenix.com would be one place to start.

The document of most interest for you at this stage would be
langref.pdf, which lists all commands alphabetically for easy
searching.

Regards,
Andrew Ferguson
-- Larger than life and twice as natural.

--- In ib-support@y..., "stevelw02" <s.lee-woolf@s...> wrote:
> Thanks Andrew, this looks like it might well be the solution to my
> problem. I'll give it a try later on (when the database is not
being
> so heavily used.)
>
> Do you happen to know if there is a definitive list of FireBird
> functions (like cast, substring etc) available anywhere? I can't
find
> any form of documentation for FB anywhere.
>
> Steve
>
> --- In ib-support@y..., "csswa" <csswa@y...> wrote:
> > --- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> > > >I am looking for something like:
> > > >
> > > >update table1 set logindate=date(login), loginTime=time
> (login) ...
> > >
> > > update table1 set logindate=CURRENT_DATE,
> > > logintime=CURRENT_TIME
> > >
> >
> > update table 1 set
> > logindate = cast(login as date),
> > logintime = cast(login as time)
> >
> > although I'm pretty sure you can just do logindate = login for
the
> > date one (implicit casting). Not sure about doing logintime =
> > login... try it and see. If it fails, revert to the casting.
> >
> > Regards,
> > Andrew Ferguson
> > -- Where did you want to go today before you ended up here?