You have to prefix a temp table with 'temdb..' as I shown in my original post. Try this one

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

RETURNS TinyInt
AS

BEGIN
	IF @sTableName LIKE '#%'
		SET @sTableName = 'tempdb..' + @sTableName
 
	RETURN CASE WHEN object_id(@sTableName) IS NOT NULL THEN 1 ELSE 0 END

END

>
>I could use your expertise here. This just isn't working:
>
>

>DROP TABLE #temp
>
>CREATE TABLE #temp (ch CHAR(1))
>
>DECLARE @sTableName VARCHAR(MAX)
>SET @sTableName = '#temp'
>
>
>IF object_Id(@sTableName)is not null
>	EXEC('DROP TABLE ' + @sTableName)
>
>CREATE TABLE #temp (ch CHAR(1))
>

>
>Any idea what I'm doing wrong here?
>
>