mysql에는 find_in_set 이라는 함수가 있는데 이를 똑같이 구현하는 방법이다. <div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div>IF&nbsp;OBJECT_ID('tempdb..#tmp')&nbsp;IS&nbsp;NOT&nbsp;NULL</div><div>&nbsp;&nbsp;&nbsp;&nbsp;DROP&nbsp;TABLE&nbsp;#tmp</div><div>create&nbsp;table&nbsp;#tmp</div><div>(</div><div>&nbsp;&nbsp;&nbsp;&nbsp;id&nbsp;int&nbsp;NOT&nbsp;NULL&nbsp;IDENTITY(1,&nbsp;1),</div><div>&nbsp;&nbsp;&nbsp;&nbsp;data&nbsp;varchar(8)</div><div>)</div> <div>insert&nbsp;into&nbsp;#tmp(data)&nbsp;values('a'),('b'),('c'),('d'),('e'),('f'),('g')</div> <div>select&nbsp;*&nbsp;from&nbsp;#tmp</div> <div>declare&nbsp;@arr&nbsp;varchar(128);</div><div>set&nbsp;@arr&nbsp;=&nbsp;'a,e,f'</div> <div>select&nbsp;*&nbsp;from&nbsp;#tmp</div><div>where&nbsp;1&nbsp;=&nbsp;1</div><div>&nbsp;&nbsp;&nbsp;&nbsp;--&nbsp;find_in_set&nbsp;함수와&nbsp;같은&nbsp;역할</div><div>&nbsp;&nbsp;&nbsp;&nbsp;and&nbsp;(exists&nbsp;(select&nbsp;1&nbsp;where&nbsp;CONCAT(',',&nbsp;@arr,&nbsp;',')&nbsp;like&nbsp;CONCAT('%',&nbsp;data,&nbsp;'%'))&nbsp;OR&nbsp;ISNULL(@arr,&nbsp;'')&nbsp;=&nbsp;'')</div></div>

[MSSQL] 동적쿼리 사용시 in clause 사용하기