At 10/16/2001 07:31 PM (Tuesday), Sandeep wrote:

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

My first reaction to this is: May I ask why? Looks perfectly good to me.

Thinking further, I realize that user defined functions CANNOT perform SQL
queries so if the function needs to do this it looks like you already have
the best solution.