title: How to get the result as 'Null' or 'Not found' for the fields which don't exist in the table
body: <p>There's a bulk file which contains the loginID of all the users in a region. Now, i need to get the username of all the IDs from the DB but there are many invalid login IDs in the file and they don't exist in the MS Sql DB.</p>
  
  <p>I tried to give the below query but it will give the result only if the login ID is present. Is there any possibility to get the result as 'Null' or 'Not found' if the loginID is not found in the DB?</p>
  
  <p><code>select username from contacts where loginID in ('xyz','abc',... upto 3K records)</code></p>