I suggest you using the view than dynamic query. One reason is that the view has been compliled, as Rory said. Another reason is view can provide you more features...