<div>
Field NAMES that begin with # or field data that begins with #?<br />
<br />
If the first:<br />
select * from inforamtion_schema.columns<wbr /><br />
where column_name like '#%'
</div>


Field NAMES that begin with # or field data that begins with #?

If the first:
select * from inforamtion_schema.columns
where column_name like '#%'

<div>
I should have said field data starting with #. &nbsp;I'll check out the link
</div>


I should have said field data starting with #.  I'll check out the link

<div>
just change the line that does:<br />
<br />
QUOTENAME('%' + @SearchStr + '%','''')<br />
<br />
to<br />
<br />
QUOTENAME(@SearchStr + '%','''')<br />
<br />
That way you are looking for it at the beginning only.
</div>


just change the line that does:

QUOTENAME('%' + @SearchStr + '%','''')

to

QUOTENAME(@SearchStr + '%','''')

That way you are looking for it at the beginning only.

<div>
&quot;I should have said field data starting with #. &quot;<br />
<br />
It helps, but I gave you an answer in case it was either! :)
</div>


"I should have said field data starting with #. "

It helps, but I gave you an answer in case it was either! :)

<div>
Thanks for your help. &nbsp;It worked great but returned 1/2 Million records. &nbsp;Took a while to go through.
</div>


Thanks for your help.  It worked great but returned 1/2 Million records.  Took a while to go through.

<div>
No doubt. &nbsp;There is no EASY way to do that.
</div>


No doubt.  There is no EASY way to do that.

<div>
<div class="content wysiwyg-content">
I'm using SQL 2005 and I need a stored procedure to help me locate all tables and field names. &nbsp;The procedures should do the following:<br />
&nbsp; Search all fields in the table for fields that begin with #<br />
&nbsp; Return the table name and all the field names beginning with #<br />
&nbsp; Do for each each table in the database
</div>
</div>


I'm using SQL 2005 and I need a stored procedure to help me locate all tables and field names.  The procedures should do the following:
  Search all fields in the table for fields that begin with #
  Return the table name and all the field names beginning with #
  Do for each each table in the database

Stored Procedure to search all tables and fields

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.