The OBJECT_ID() function will return a NULL if the object does not exist.
SELECT OBJECT_ID('peoption')
-Mike
>I currently check for the existence of a specific file in a specific location to determine if a "module" is installed.
>
>RETURN file(_screen.mvApplication.DataDirectory + "PEOPTION.DBF")
>
>How can I accomplish the same thing in SQL Server?