find fields

hi, how to find the fields have "&abc" as the caption in the database?
thanks...Do you mean the extended property, description?
http://www.aspfaq.com/2244
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"js" <js@.someone.com> wrote in message
news:ONSPaDVRFHA.2252@.TK2MSFTNGP15.phx.gbl...
> hi, how to find the fields have "&abc" as the caption in the database?
> thanks...
>
>|||Thanks Aaron,
I want fo find what fields have the "abc" in what tables as the field
captions.
Can I use a query to get them?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uQJWxnVRFHA.3664@.TK2MSFTNGP15.phx.gbl...
> Do you mean the extended property, description?
> http://www.aspfaq.com/2244
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
> "js" <js@.someone.com> wrote in message
> news:ONSPaDVRFHA.2252@.TK2MSFTNGP15.phx.gbl...
>|||Hi,
Select TABLE_NAME,COLUMN_NAME from FORMATION_SCHEMA.COLUMNS where
COLUMN_NAME like '%ABC%'
You can also query system table SYSCOLUMNS
Thanks
Hari
SQL Server MVP
"js" <js@.someone.com> wrote in message
news:%23zQX4wVRFHA.3476@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron,
> I want fo find what fields have the "abc" in what tables as the field
> captions.
> Can I use a query to get them?
>

> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:uQJWxnVRFHA.3664@.TK2MSFTNGP15.phx.gbl...
>|||> I want fo find what fields have the "abc" in what tables as the field
> captions.
I don't know what you mean by "field captions"... there are no fields and
there are no specific things called captions. There are columns which have
a name and *can* have a description. Can you please be more specific about
what you are looking for.|||That's it. Thanks...
"Hari Pra" <hari_pra_k@.hotmail.com> wrote in message
news:uP%230cIWRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Select TABLE_NAME,COLUMN_NAME from FORMATION_SCHEMA.COLUMNS where
> COLUMN_NAME like '%ABC%'
> You can also query system table SYSCOLUMNS
> Thanks
> Hari
> SQL Server MVP
>
> "js" <js@.someone.com> wrote in message
> news:%23zQX4wVRFHA.3476@.TK2MSFTNGP10.phx.gbl...
>
>