Hi,

At January 8, 2004, 02:46, James wrote:
[...snip...]

> so what this stored procedures does is splitting the amount according to
> its type. can I do something like this without doing it in stored
> procedure but in select statement only?

Yes, you can with FB 1.5. Look at the new CASE predicate. The
information is in the release notes.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)