The best is uses NUMBER(1) because checkbox can use .T./.F. or 1/0 or 2=.NULL.

MartinJ
>>use char(1)
>>
>Thanks Tracy. We can use this but the problem is with the existing codes. I am going to look at the CursorAdapter events to manage this. I was hoping that there is already a best practice solution that I code to.