Daniel Rail wrote:

>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.
>
>
>

Thanks Daniel.

But what if I don't want to use to case predicate? Is there still a way
to do it?

Cheers

James