Michael,

The view definition contains the length of a char() column. It may not be long enough.

>OK, now this one is strange:
>
>When I do a view to a SQL table the view is not giving me the last character in one of fields.
>
>I believe that character is in the database, because my query is against that field and it pulls up the record if I include that character, and does not pull it up if I don't.
>
>So: The field contains a string like this: GG-12121A
>
>If I query against that field using a view and ask for GG-12121A, it finds the record but the result table contains GG-12121
>
>If I search for GG-12121 (without the A), then no matches are found.
>
>Help!