Hello Daniel,

Thanks for your message. I found a solution, maybe isn't the best
solution but solve my problem:

Select (select N1 From split_nr(op.Trezorerie_NR)) N1,
(select N2 From split_nr(op.Trezorerie_NR)) N2,
Trezorerie_NR,....
From Trezorerie left join................

In the future I will change the view with a SP.

Monday, February 9, 2004, 3:57:37 PM, you wrote:

>> The next sql works just fine:
>> select *
>> FROM VA_OP Op
>> left join split_nr(Trezorerie_NR) sp on 1=1

..........................
DR> It's not a bug. Views don't support Stored Procedures, nor parameters.
DR> Most SPs are designed that they require at least one input parameter,
DR> and you can't pass a parameter into a View from outside a View.
DR> Otherwise a View would be just a simpler selectable SP.
--
Best regards,
DragosH mailto:dragosH@...