>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!
Are you using any expressions in your view? You need to make sure that the result of any expression will produce a field of a consistent length. Things like ALLTRIM() are discouraged unless you wrap it in a PAD() function that creates the proper field size.