Find A Field Name In SQL Server

SELECT sysobjects.name
FROM syscolumns
LEFT JOIN sysobjects on sysobjects.id = syscolumns.id
WHERE syscolumns.name LIKE '%fieldname%'
ORDER BY 1