<div>
<div class="content wysiwyg-content">
I have the following list of items I want to use in an &quot;&nbsp;IN &quot;&nbsp;statement and would like to declare them at the beginning. &nbsp;What's the best way to handle this.<br />
<br />
SET @APPTTYPE = '('BOTOX', 'CONSLT20', 'CONSLT30', 'CONSLT40', 'CONSLT50', 'CONSLT60', 'EMG/NCS', 'EN20', 'EN30', 'EN40', 'EN50', <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'EN60', 'EO20', 'EO30', 'EO40', 'EO50', 'EO60', 'JNT INJ', 'MVA')'
</div>
</div>


I have the following list of items I want to use in an " IN " statement and would like to declare them at the beginning.  What's the best way to handle this.

SET @APPTTYPE = '('BOTOX', 'CONSLT20', 'CONSLT30', 'CONSLT40', 'CONSLT50', 'CONSLT60', 'EMG/NCS', 'EN20', 'EN30', 'EN40', 'EN50', 
                      'EN60', 'EO20', 'EO30', 'EO40', 'EO50', 'EO60', 'JNT INJ', 'MVA')'

SQL Declare

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.