title: Limit of arguments on Coalesce SQL function?
body: <p>I am working on a logic for ID types there are about 20 of them and I do this <code>IDType = COALESCE(1,2,4,5,6,7,8,9,10,11,12,13,15,16,17,18,19))</code> under where clause in the query. </p>
  
  <p>1) For a record with types 1 and 12. When 1 is satisfied, 12 is ignored and I see only one result (obviously two before).</p>
  
  <p>2) A record has type ID 6,8,11. And I expect it to pick 6 and drop 8 and 11 types as per order specified in Coalesce but this isn't working. Interestingly, I don't find any result for this record.</p>
  
  <p>Is there a limit on number of arguments in Coalesce function as in first case it was picking up 1 and ignoring 12 and in second case it didn't pick up any ID type. Please help #NewToSQL</p>