Unfortunately ... that didn't seem to help :( I used btrim on all the
fields that were part of an equals (=) statement and reran the select
and got the same result (0 rows). After I was in the process of
updating the tables, I thought that this may fail ... since again, the
'manual join' of these two tables returns the correct results ... and it
uses the same equality tests as the SQL join.
I'm more than happy to keep tryin' different things, though ... anything
to get to the bottom of this.
Regards,
Brice Ruth
"Ross J. Reedstrom" wrote:
>
> Brice -
> What's the result of
>
> select monographid,length(monographid) from tblpemdruglink where
> monographid ~ '^2008';
>
> It occurs to me that your delimited text file may have padded values,
> and "=" insists on exact matches for VARCHAR.
>
> update tblpemdruglink set monographid=btrim(monographid);
>
> might help, if the first query returns anything but 4.
>
> Ross
>
> On Tue, Feb 06, 2001 at 05:22:59PM -0600, Brice Ruth wrote:
> > Here's something to chew on ...
> >
> > The following snippet of SQL produces a result:
> >
>
> <SNIP>
>
> > Please respond to this newsgroup, the mailing list (which should be
> > mirrored on the newsgroup), and/or to me personally. I'm twiddlin' my
> > thumbs until I can figure this one out.
> >
> > Regards,
> > Brice Ruth