Good question. Couple of issues with the construction of it though:
1. Unless the database context is set to tempdb, or you explicitly reference tempdb..sysobjects, you will get no rows returned.
2. If you are using the wildcard (%) character, the '=' will need to be changed to 'LIKE'. Again, no rows returned otherwise.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare