>
> > You need to do some homework on paramatised queries.
>
> alan, thank you - and yes i have mountains of homework seems like there
> is always more to learn.
>
> one more before i knock off, would there be any performance advantage
> in creating a stored procedure instead of a parameterized query?
>
> thank you again,
> gabe
>

you'd still need to prepare it and thus you are best advised to use
paramaters with it. Otherwise there would be litle difference other than
perhaps enhanced security options over it's access.
Alan