>Hello all
>
>ok, it's been a while since I had to deal with straight T-SQL and I'm trying to create a table
>
>Create table CATMaster (CATID int identity(1,1), Category varchar(2), diff varchar(1), ALC varchar(5), Keyword varchar(25),
> Keyword2 Varchar(25), keyopt varchar(1), script varchar(500), stem varchar(500), respa varchar(115),
> respb varchar(115),respc varchar(115), respd varchar(115), scripttime varchar(2), testtype varchar(1),
> EntBy VarChar(3), EntDate date, RevBy Varchar(3), RevDate date, Completed varchar(1)
>
>It keeps telling me "The specified data type is not valid. [ Data type (if known) = varchar ]"
>
>Ok, I'm confused. What am I not seeing?
>
>Thanks
You are missing closing bracket:
, Completed varchar(1))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.