> > 2) When my customer tried running it, he got the following error:
> >
> > ISC ERROR CODE: 335544321
> > arithmetic exception, numeric overflow, or string truncation
> >
> > What could cause that error?
>
>That at least in one case the resulting field ( proddesc || other values
>that you concatenate here) is longer than the proddesc is declared.
>Example:
>PRODDESC = VARCHAR(50)
>Length of entry Length of appended value
>30 10 ok
>40 10 ok
>40 11 not ok, since Result is 51
>1 40 ok
>1 50 not ok

Is there any way to test for this in my query? i.e. something like...

...and length(proddesc) < 30

That is, other than a SP or UDF?

-Joe