<div>
Define 'above special characters', and please give us a before and after data set of what you're trying to pull off here.
</div>


Define 'above special characters', and please give us a before and after data set of what you're trying to pull off here.

<div>
sorry above special characters are<br />
', / ( ) . &quot;
</div>


sorry above special characters are
', / ( ) . "

<div>
<div class="content wysiwyg-content">
Hi All,<br />
I used following code to group data and insert into the &nbsp;Drop down box to search records via users. But im not <br />
getting correct output. i guess because of special characters. i just wondering how to use search &nbsp;without deleting above<br />
special characters. Any idea appreciate.<br />
<br />
Drop down box - sql code<br />
select [Company Name] From database1 GROUP BY [Company Name] <br />
<br />
<br />
Search code<br />
<br />
select [Company Name],Name,[Address 1],[Address 2],[City] From database1 &nbsp;WHERE [Company Name] IN(@CompanyName)
</div>
</div>


Hi All,
I used following code to group data and insert into the  Drop down box to search records via users. But im not 
getting correct output. i guess because of special characters. i just wondering how to use search  without deleting above
special characters. Any idea appreciate.

Drop down box - sql code
select [Company Name] From database1 GROUP BY [Company Name] 


Search code

select [Company Name],Name,[Address 1],[Address 2],[City] From database1  WHERE [Company Name] IN(@CompanyName)

T-sql Search results issue

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

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.