hi,<BR>i am tring to add a field to an existing table using ASP.<BR>So i use this"<BR>SQL = "alter table tblname add column columnname YESNO"<BR>it is working but the field value is creating having value 0 or 1.i mean that the display control of the field is text box i want the display value to be check box.<BR>This is the problem i hope that someone can help me.<BR>Thank u.<BR>