>How do you pass the parameter to Object_ID when the table name is being passed in?
>

CREATE FUNCTION dbo.fnTableExists
	(@sTableName VARCHAR(50))

RETURNS TinyInt
AS

BEGIN

	RETURN CASE WHEN object_id(@sTableName) IS NOT NULL THEN 1 ELSE 1 END

END