title: Convert CHAR to NUMERIC in SQL
body: <p>I am trying to set up a database that has the following columns, "number", "full names", "card no", "status". In the last column status there are many types of status, which I would like to have them converted to 0 or 1 to another column within the table, depending on the statuses. The database then, is to be pulled to another application and will use the binary column to give access to a facility.</p>
  
  <p>I have not tried any code on this, still learning.</p>
  
  <pre><code>SELECT TOP 1000 [MemberNo]
        ,[FirstName]
        ,[LastName]
        ,[CardNo]
        ,[Status]
    FROM [GateAccess].[dbo].[GateProxy]
  </code></pre>