Dmitry,

Try this:

select sobj.name as ctblname, syscol.name as ccolname
from syscolumns syscol
left outer join sysobjects sobj on syscol.id = sobj.id
where sobj.type = 'U' and charindex('XYZ', syscol.name) > 0
order by 1,2


>Is there a command that would tell you which tables have a field/column name "XYZ" or which field names contain "XYZ"?
>
>Thank you.