>That's wrong way to do it.

Just interested, why do you think so? If the age field is bound to a certain event in time (like age at date of surgery), it does make sense to calculate and store it in a table.


>>I have table "merit.dbf" having field with 1. Regno 2. Name 3. Caste 4. dob 5. Age
>>The data type of dob field is Character type. I want to calculate age for each student and put in the age field.
>>
>>The table look like below
>>
>>Regno Name caste dob age
>>30001 S. sakthi GE 01/08/1994
>>30002 K. Karthi GE 15/07/1994
>>30003 N. Kumar GE 25/09/1995
>>30004 R. Mano SC 10/03/1994
>>30005 L. Kavi SC 09/05/1995
>>
>>How to calculate age and put in age field?