On 17 Oct 2001, at 1:27, Markus Ostenried wrote:

> Hi,
>
> just a thought... have you tried something like the following ?
>
> select * from tableA a
> where a.Field = select outputParam from MyStoredProc( Val );

That's what I use right now and I was trying to get away from writing

[ select outputParam from MyStoredProc( Val ) ]

everytime i want to get that value

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz