Search Tables for Column Name

Depending on the level of convolutedness, one may, hopefully rarely, be required to search for all tables containing a particular column name.  I found myself in this situation today.  Refer to below T-SQL.

SELECT		so.name
FROM		sys.sysobjects AS so WITH(NOLOCK) INNER JOIN
			sys.syscolumns AS sc WITH(NOLOCK) ON so.id = sc.id
WHERE		(so.xtype = 'U') AND (sc.name = N'Column_Name')
ORDER BY	so.name