Subject Re: [ib-support] Functions
Author Markus Ostenried

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

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


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