Thank you all.  This is great information.  However, we have run into a problem...  Taking the original code we modified it as follows and at first it worked returning a...

Thanks for chiming in here Phil and yes, I do know about parameterized views not being possible.  My first thought was to change my view to a stored procedure since...