My problem (excuse me for being a novice) is that whenever the query becomes complex in the @whereclause (and it does) it cant exceed the character limit of a nvarchar. Now if someone could shed some ligfht on this for me I would be incredibly grateful. I have tried doing the exec(@var1 + @var2) but...