Hi Andy

Thanks for this info and I can see how it works when running the query

select * from dbo.Contact where lastname = 'green'

However when trying the following, it reverts to looking at both underlying tables again

DECLARE @lastname VARCHAR(10)

SET @lastname = 'green'

select * from dbo.Contact where lastname = @lastname

Is there any way this can only look at the one table? Or would I have to write my stored procedures using dynamic sql to take advantage of this?