title: An expression of non-boolean type specified in a context where a condition is expected - SQL Server REGEXP_LIKE
body: <pre><code>CREATE TABLE Contesters 
  (
          contester_id int primary key NOT NULL,
          full_name varchar(50) NOT NULL,
          email varchar(50) NOT NULL UNIQUE,
          phone_num varchar(12) NOT NULL UNIQUE,
          birthday date NOT NULL,
          age tinyint NOT NULL,
          datetime_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
          passport_num bigint NOT NULL UNIQUE,
          median_res tinyint NOT NULL,
          bio varchar(200) NOT NULL,
          presentation_vid varchar(50) NOT NULL,
          CONSTRAINT full_name_cc CHECK (dbo.REGEXP_LIKE(full_name, '^[а-яА-ЯёЁa-zA-Z]+ [а-яА-ЯёЁa-zA-Z]+ ?[а-яА-ЯёЁa-zA-Z]+$')),
          CONSTRAINT email_cc CHECK (dbo.REGEXP_LIKE(email, '^[-\w.]+@([A-z0-9][-A-z0-9]+\.)+[A-z]{2,4}$')),
          CONSTRAINT phone_num_cc CHECK (dbo.REGEXP_LIKE(phone_num, '^((\+7|7|8)+([0-9]){10})$' ))
  )
  </code></pre>
  <p>This code throws an error</p>
  <blockquote>
  <p>Token error: 'An expression of non-boolean type specified in a context where a condition is expected, near ')'.' on server c349b3de3b7b executing on line 13 (code: 4145, state: 1, class: 15)</p>
  </blockquote>
  <p>I'm trying to add a regex check when creating a table. This method worked a while ago, but now it seems to throw an exception.</p>