The other way this could happen is if you are inserting data using
SQL*Loader, and the datafiles have embedded spaces in them. For this
reason, I usually load data from SQL*Loader into temporary tables, and then
do inserts with rtrims and ltrims into permanent tables.
Louise
Gene Hubert <110530.717_at_CompuServe.COM> wrote in message
<#HnNoUVJ#GA.204_at_nih2naab.prod2.compuserve.com>...
>I'm running Oracle 8.0.3 on NT 4.0.
>
>I occasionally run across data in varchar2 columns that has
>trailing spaces. Comparisons on this data will fail without an
>rtrim or adding the right number of spaces to what is being
>compared. Can anyone explain how varchar2 data ends up with
>trailing spaces? I thouhgt this was not possbile.
>
>Gene Hubert
>Qualex Inc.
>Durham, NC
>
Received on Sun Dec 13 1998 - 10:21:41 CST
