This tip shows how powerful the CASE expression is, and some of the nuances in its behavior.

See one approach to collecting extended properties information across all of the databases on a server.