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

"Larry Gibson" <> wrote in message
> 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
> in the tempdb before trying to create it? Thanks.