Hi Reno,
It's bad idea to use system tables directly because MS doesn't guarranty that they wouldn't change between versions. There're some cases where there is no other way to achive something but it isn't the one of those.
>
>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.
--sb--