<div>
<i>Can I use &quot;LIKE&quot; in place of &quot;IN&quot; </i><br />
<br />
If #session.userRoleUnits# contains multiple values - then NO. &nbsp;What you could do is loop through the list and generate a LIKE statement for each one as @nmarano described above<br />
<br />
WHERE &nbsp;.....<br />
&lt;cfloop list=&quot;#session.userRoleUni<wbr />ts#&quot; index=&quot;unit&quot;&gt;<br />
&nbsp; &nbsp; AND tblPerson_RTIDetail.person<wbr />Unit LIKE '#unit#%'<br />
&lt;/cfloop&gt;<br />
<br />
<i>#PreserveSingleQuotes(sess<wbr />ion.userRo<wbr />leUnits)#</i><br />
<br />
( I've probably mentioned it before, but that's a very dangerous function to use on sql server )
</div>


Can I use "LIKE" in place of "IN"

If #session.userRoleUnits# contains multiple values - then NO.  What you could do is loop through the list and generate a LIKE statement for each one as @nmarano described above

WHERE  .....
<cfloop list="#session.userRoleUnits#" index="unit">
    AND tblPerson_RTIDetail.personUnit LIKE '#unit#%'
</cfloop>

#PreserveSingleQuotes(session.userRoleUnits)#

( I've probably mentioned it before, but that's a very dangerous function to use on sql server )

<div>
Yes it will have multiple values. <br />
<br />
Why is it a dangerous function? Thanks for bringing it to my attention.<br />
<br />
I'll go try this now.
</div>


Yes it will have multiple values.

Why is it a dangerous function? Thanks for bringing it to my attention.

I'll go try this now.

<div>
<div class="content wysiwyg-content">
I have a query and I'm trying to see if one of the SQL variables is LIKE one of the items in a list. At the end of the query I have <br />
<br />
&nbsp; <b>AND tblPerson_RTIDetail.person<wbr />Unit IN (#PreserveSingleQuotes(ses<wbr />sion.userR<wbr />oleUnits)#<wbr />)</b><br />
<br />
This appears to be doing only a direct match. Can I use &quot;LIKE&quot; in place of &quot;IN&quot; and, if so, how would I place the %? <br />
<br />
Thanks a lot!
</div>
</div>


I have a query and I'm trying to see if one of the SQL variables is LIKE one of the items in a list. At the end of the query I have 

  AND tblPerson_RTIDetail.personUnit IN (#PreserveSingleQuotes(session.userRoleUnits)#)

This appears to be doing only a direct match. Can I use "LIKE" in place of "IN" and, if so, how would I place the %? 

Thanks a lot!

SQL query of a ColdFusion List

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

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

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.