Any wouldn't you just know it, I see the answer to my question already
posted below. Thanks.

"Larry Gibson" <hhompacbell.net> wrote in message
news:%23tbRH5lQDHA.560TK2MSFTNGP10.phx.gbl...
> I remember seeing a post some time ago of a way to see if a specific
> temporary table exists. I can't seem to get the standard
>
> if exists (select * from sysobjects where id=object_id(table name) and
> OBJECTPROPERTY(id, 'IsUserTable') = 1)
>
> to work. Anyone know a quick way to check to see if a table already
exists
> in the tempdb before trying to create it? Thanks.
>
>