ya this is the acrt table now as i have it in our system and negwatch is last column

probably missing the last braket didnt copy and past the lot thought i had sorry

CREATE TABLE dbo.ACRT

(

CNO CHAR (100) NOT NULL,

OPICSCNO CHAR (100) NULL,

MOODYSRATE CHAR (10) NOT NULL,

SNPRATE CHAR (10) NOT NULL,

FITCHRATE CHAR (10) NOT NULL,

MOODYSIRB numeric (4) NULL,

SPIRB numeric (4) NULL,

FITCHIRB numeric (4) NULL,

MOODYSWATCH bit DEFAULT 0 NOT NULL,

SPWATCH bit DEFAULT 0 NOT NULL,

FITCHWATCH bit DEFAULT 0 NOT NULL,

MIDRATEAGENCY CHAR (10) NULL,

MIDRATING CHAR (10) NULL,

MIDIRB numeric NULL,

NEGWATCH bit DEFAULT 0 NOT NULL,

)