Can you provide the DDL for the table?

Is the Company Name in the same table?

You could do something like this:

IF OBJECT_ID('tempdb..#company', 'U') IS NOT NULL

BEGIN;

DROP TABLE #company;

END;

CREATE TABLE #company

(

CompanyId VARCHAR(10),

CompanyName VARCHAR(50),

CONSTRAINT CK_Company_CompanyId CHECK (LEFT(CompanyId, 3) = LEFT(CompanyName, 3))

);

/* Succeeds */

INSERT INTO #company

(CompanyId, CompanyName)

VALUES

('JAC001', -- CompanyId - varchar(10)

'JACK CORBETT' -- CompanyName - varchar(50)

);

/* Fails */

INSERT INTO #company

(CompanyId, CompanyName)

VALUES

('JA0001', -- CompanyId - varchar(10)

'JACK CORBETT' -- CompanyName - varchar(50)

);

SELECT

*

FROM

#company AS C;