Randy,

I haven't used SQL Server views, but I don't see any reason why you can't just leave it there.

~~Bonnie

>Well, I was able to create the view through code. Now that I have run the code once to create view, can I just leave it there instead of dropping it? Will this cause any problems? TIA