I want to change the YEAR field from numeric to characters
How ?
So if YEAR is 1987, what would you want it to to read?
I'd think very carefully about doing this. Most software will expect a numeric date, and the majority of that software will only read a four digit year. Anything else may be rejected and treated as blank.