title: Splitting a row based on a condition
body: <p>i have a scenario. In a table i got 2 fields which checks for a patients. For example, if a patient has 'A' or if a patient has 'B'. </p>
  
  <p>But when i pull the record, i want 2 records, one for A and one for B. I know this could be done using UNION ALL but is there a different way to do that because UNION ALL will be way too bulky code for me. Please help!</p>
  
  <p>Example would be like this.</p>
  
  <p>In Table Patients</p>
  
  <pre><code>PatientID Name         Age HasA HasB
  1234      Sad          18  Yes  Yes
  4567      Happy        40  Yes  No
  8901      confused     25   No  Yes
  </code></pre>
  
  <p>so my query should return:</p>
  
  <pre><code>PatientID Name         Age Has
  1234      Sad          18  A 
  1234      Sad          18   B
  4567      Happy        40  A
  8901      confused     25   B
  </code></pre>
  
  <p>so a sort of duplicate row if it has both A and B.</p>