At 12:30 PM 1/11/2003 +0100, you wrote:

>Hello
>
>I get a char(10), called dep_date, as input to a stored procedure.
>the format of the value is YYYY-MM-DD.
>
>How do I allocate a new var in the SP and set it to the day before dep_date.
>
>example.
>dep_date is '2003-03-01', the local var should be '2003-02-28'

declare the local var as a DATE type:

..
declare variable DateVar DATE;
...
DateVar = cast(dep_date as DATE) - 1;

>
>Where can I find SP documentation? And where can I find documentation of
>all functions that can be used in a SP?

Language Reference book (LangRef.pdf) of the IB 6 beta docs + Firebird
release notes.

heLen