I have since discovered the conditions under which enterprise manager won't accept the data - upon entry into the field, the field is highlighted. If I overwrite the data ENTIRELY with my new edited value, it works fine. If I position my cursor in the middle, and insert new data, it complains.

Maybe this is by design, or just a limitation of the data entry interface in enterprise manager?

>I am attempting to use enterprise manager to edit data in one of my system tables. I have a column - citmexp char (200).
>
>The current value in it is substring(citemno,1,3)
>
>I am attempting to change it to:
>
>substring(iciwhs.citemno,1,3)
>
>a simple change. No triggers or special constraints are on the table or columns.
>
>Enterprise manager says 'the value you entered is not consistent with the data type or length of the column'
>
>I can't for the life of me determine what would be invalid about the data. Any ideas?
>
>TIA