title: SQL Server - Simple multiple choice field definition
body: <p>I am new to SQL Server, coming from a MySQL background. I am trying to migrate a MySQL table that contains several fields defined similarly to the following one:</p>
  
  <pre><code>"FavoriteColors" SET('Red','Blue','Dark Purple', 'Green') DEFAULT NULL,
  </code></pre>
  
  <p>Basically, they are multiple-choice questions. When entering these fields in a form, the user will be able to select one or more of them.</p>
  
  <p>When looking for a SQL Server equivalent to this definition, I have seen that many people create an extra table for the different choices, and then a lookup table to connect the two previous ones. Knowing that there are several multiple-choice fields like this one, it seems a pretty complicated solution for such a simple definition. Is this really best practices, or do you recommend an alternate solution? Of course, I can use BIT fields for each of the choices, but again, it seems to me that SQL Server probably has a simpler, better organized solution for this.</p>
  
  <p>Thanks a lot!</p>