Hi,

just a thought... have you tried something like the following ?

select * from tableA a
where a.Field = select outputParam from MyStoredProc( Val );

HTH,
Markus

At 10:41 17.10.2001 +1300, you wrote:

>Is there any way of declaring ones own function (not external) like
>Upper, cast, stc in database.
>
>What I want is a way to have the foolowing statement
>
>select * from tableA a
>where a.Field = functionA (Val);
>
>where functionA returns some value based on input parameter Val.
>
>Regards
>
>Sandeep
>
>Software Developer
>CFL
>sandeep@...
>http://www.cfl.co.nz