Give Conditional Foreign key

See more:

SQL

Hi..

I have Two tables with column names :

TABLE [dbo].[Colleges](
    [CgCode] [varchar](10) NOT NULL,
    [CgName] [varchar](120) NOT NULL,
    [CgType] [varchar](5) NOT NULL,

 CONSTRAINT [PK_Colleges] PRIMARY KEY NONCLUSTERED([CgCode] ASC)

TABLE [dbo].[CodeTable](
    [CdType] [varchar](5) NOT NULL,
    [CdCode] [varchar](5) NOT NULL,
    [CdSeq] [smallint] NOT NULL,
 CONSTRAINT [PK_CodeTable] PRIMARY KEY CLUSTERED([CdType] ASC,[CdCode] ASC);

I want to give foreign key(FkCgCd) to Colleges with condition
(where CgType=CdCode and CdType="CG") is such possible??