Re: which function does this?.

["jdeline"]

> Too complicated? It's a simple join for goodness sakes.

 I was not referring to your query with the JOIN; it wasn't posted when I 
replied.  I was referring to the original post's WHERE clause: 
 where empid in (<cfloop query="id_sel" startrow="1" 
endrow="#id_sel.recordcount#">
 #valueList(id_sel.empid,",")#</cfloop>)