Hello out there again. Thanks for the help on the previous problem. Can anyone tell me how can I check whether a view exists, and if it exists to drop it. I'm using ASP with SQL Server 7 on a Windows NT Server 4.0. Thank you Marios _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.