> > Is there any way to treat it like an inline function so that I could write
> > something like the following (highly simplified):
>
> I think 7.4 will inline simple SQL functions. Your CASE looks like a good
> candidate.
>
> > select case when A=1 then 1 when B=1 then 2 else null end
> > as mailtype, memname from master
> > where mailtype is not null;
I think it may inline it as an optimization step, I don't know of any
way to shortcut how to write it. (I'm running 7.4.1.)
--
Mike Nolan