 <p>Concerning your first question, have a look at the following SQL code:</p> <p>CREATE TABLE 'test' ('col' varchar(10) NOT NULL, 'col2' varchar(25) NULL);</p> <p>ALTER TABLE 'test' ADD CONSTRAINT 'U' UNIQUE ('col');</p> <p>Here a table "test" is created, containing a collumn "col" which has 10 digits and must be unique.</p> <p>(unfortunately I can't help you concerning SugarCRM)</p>