No the problem is not in the if body.

If I eliminate the test altogether, the procedure does not fail.

Even if I do nothing inside the body of the if statement, it fails on
the if (InternalMemo <> '') line.

Rick

--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> > I have a mysterious failure in an SP when I check if a variable

is

> > blank.
> >
> > I get a "arithmetic exception, numeric overflow, or string

truncation"

> > when I test for InternalMemo <> ''.
> >
> > InternalMemo is VarChar(2000) and is filled from a memo field

like this:

> > Select...<field list>
> > Coalesce(SubString(O.MEMO_INTERNAL From 1 For 1990),'')
> > into ... InternalMemo
> >
> > Then later in the procedure I check to see if it contains

something by:

> > if (InternalMemo <> '') then
> > ...do something
> >
> > But I get the error at the "If" test
>
> Isn't problem somewhere in the "...do something" part ?
>
> Ivan
>