Pass a two character

[mcupryk]

How do I pass a two character for dr.Item(4) in the following:

ExecOnTransOverride.ins(dr.Item(1), dr.Item(2), dr.Item(3), dr.Item(4), dr.Item(5), dr.Item(6), dr.Item(8), dr.Item(7), DateTime.Now, dr.Item(7), dr.Item(9)) 


+ dr.Item(1) "1234555" {String} Object 
+ dr.Item(2) "CANADJ" {String} Object 
+ dr.Item(3) #9/22/2005# {Date} Object 
+ dr.Item(4) "ACCOUNT" {String} Object 
+ dr.Item(5) "N" {String} Object 
+ dr.Item(6) "COMMCH" {String} Object 
+ dr.Item(7) "za\mmmmmm" {String} Object 
+ dr.Item(8) #8/28/2005 10:58:13 PM# {Date} Object 
+ dr.Item(9) 2222 {Integer} Object 

I am getting this error

http://www.vbcity.com/forums/topic.asp?tid=111180
Insert Statement Conflict Column Check Constraint 

CREATE TABLE [TransOverride] ( 
[Policy_Nbr] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , 
[Trans_CodeOrig] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , 
[Trans_Eff_Date] [datetime] NOT NULL , 
[Override_Code] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , 
[NR_CodeOvr] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , 
[Trans_CodeOvr] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , 
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF__TransOver__Creat__70A8B9AE] DEFAULT (getdate()), 
[CreatedUID] [nvarchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , 
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF__TransOver__Modif__719CDDE7] DEFAULT (getdate()), 
[ModifiedUID] [nvarchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , 
[Plan_Year] [int] NOT NULL CONSTRAINT [DF__TransOver__Plan___56757D0D] DEFAULT (2004), 
CONSTRAINT [cnTransOverride_PK] PRIMARY KEY  CLUSTERED 
( 
[Policy_Nbr], 
[Trans_CodeOrig], 
[Trans_Eff_Date] 
)  ON [PRIMARY] , 
CONSTRAINT [cnTransOverride_NR_CodeOvr_CK] CHECK ([NR_CodeOvr] = '' or ([NR_CodeOvr] = 'R' or [NR_CodeOvr] = 'N')), 
CONSTRAINT [cnTransOverride_Override_Code_CK] CHECK ([Override_Code] = '' or ([Override_Code] = 'OT' or ([Override_Code] = 'AU' or ([Override_Code] = 'MS' or ([Override_Code] = 'EN' or ([Override_Code] = 'AO' or [Override_Code] = 'AC')))))) 
) ON [PRIMARY] 
GO