hi,
thank you very much,
YES qdate C(30) , date type
1.can i do that as qdate d(8).
2. if this field have date and time how i can identfy the type.

sorry for boor English language.

>>hi all,
>>
>>i try to create table , some fields as number(numaric)TYPE
>>

>> CREATE TABLE home(list_no N(10), customer_tel C(15),name C(80), area_no C(10),account C(10), qdate C(30),home C(10), bus C(40),survey_no c(10), flag N(10),n_try N(10)  NOCPTRANS)
>>

>>THANKS
>
>Use the NOCPTRANS keyword after each character fields where you need, it has no meaning for a numeric field like you have used it.

>CREATE TABLE home (list_no N(10), cust_tel C(15) nocp ,name C(80) nocp, area_no C(10) nocp ,account C(10), qdate C(30) nocp,home C(10) nocp, bus C(40) nocp,survey_no c(10) nocp, flag N(10),n_try N(10))

>And note that customer_tel is more than 10 character, and NOT a legal fieldname in a free table.
>Also if qdate is a date, you should use a date field type!!!