title: Oracle SQL - How to add a filter on a case field that I created?
body: <p>I'm relatively new to Oracle SQL and have run into an issue where I'm trying to filter a report to only return records logged by a specific list of user names.</p>
  
  <p>They are currently stored in the system in fields user.first_name and user.surname and I've created the following CAST field in the coding to join the two together:</p>
  
  <pre><code>CAST(USER.FIRST_NAME||' '||USER.SURNAME as VARCHAR (25)) as CUSTOMER
  </code></pre>
  
  <p>What I want to do now though is restrict it so that my query will only return records where the customer is in a pre-determined list that I can hard core into the SQL.
  eg I only want to see records for :
  Joe Bloggs,
  John Doe,
  A Nother</p>
  
  <p>How do I do this in Oracle SQL?</p>
  
  <p>Thanks</p>