>Can you please tell me how can i add the column field2 which is charecter binary 200.

Use the NOCPTRANS keyword for that field in the ALTER TABLE command.

Doug