Rene,
Thank you for your suggestion. Even though the approach suggested by Sergey worked very well, I will try your approach, just to see if I can learn something about SQL Server (since I have done very little with SQL Server).
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
