title: Create Table using SQL with primary key starting with 'A'
body: <p>I'm trying to create a table using SQL. I want my <strong>primary key</strong> <strong>- ArCode</strong> to start with the letter <strong>'A'</strong>. I have used combinations of <strong>check</strong> and <strong>like</strong> but to no avail.</p>
  
  <p>Here is my Query:</p>
  
  <pre><code>Create table Article(
  ArCode Char(5) Check (ArCode LIKE 'A%') Primary Key,
  ArName Varchar2(30) Not Null,
  Rate Number(8,2),
  Quantity Number(4) Check (Quantity &gt;=0) Default 0,
  Class Char(1) Check (Class In ('A','B','C'))
  );
  </code></pre>
  
  <p>When I execute the query I get a <strong>missing right parenthesis</strong> error. I'm not able to figure it out.</p>