title: How can i find if a string is present in a collection of comma seprated strings in sql server?
body: <p>I want to find if a string is present among a collection of string in sql .
  Given code is always returning false.Can anyone plz tell me where am i wrong ? </p>
  
  <pre><code>alter procedure is_exception_user @usrid varchar(100)
  as
  begin
  if @usrid in ('abc,xyz')
  SELECT 'TRUE'
  ELSE 
  SELECT 'FALSE'
  END
  
  exec is_exception_user 'xyz'
  </code></pre>