The strim did not make the problem go away!
Mike Sinclair
Bernie Corrigan wrote:
>
> Jim -
> I disagree. "Jim Blackburn " does not equal "Jim Blackburn
> ". We can of course arbitrarily specify that trailing blanks are not to be
> used in string comparisons; however, they are characters. LIKE handles the
> original problem. I'm a bit surprised that what appears to be an automatic
> STRIM takes place before the compare in the BROWSE from both tables
> command's implicit view.
>
> Bernie
> ======================================
> At 08:40 AM 6/4/2001 -0800, you wrote:
> >Mike:
> >The logic of your command is very clear. I would not be happy trying to
> explain that failure to one of our research biologists. It is clearly a bug.
> >
> >My $0.02,
> >Jim Blackburn
> >Kodiak
> >
> >MJS wrote:
> >I was looking for a concensus on wether or not to submit it to RDCC.
> >>
> >> Mike Sinclair
> >>
> >> Ben Petersen wrote:
> >> >
> >> > Mike,
> >> >
> >> > Try:
> >> >
> >> > Brow * from diaginfo t1, pasthist t2 whe t1.diagname = t2.disease
> >> >
> >> > Ben Petersen
> >> >
> >> > On 4 Jun 2001, at 8:20, MJS wrote:
> >> >
> >> > > the following does not yield any rows.....
> >> > >
> >> > > BROWSE ALL FROM diaginfo WHERE diagname IN (SELECT disease FROM
> >> > > pasthist)
> >> > >
> >> > > But this works...
> >> > >
> >> > > BROWSE ALL FROM diaginfo WHERE (SGET(DIAGNAME,36,1)) in (SELECT DISEASE
> >> > > FROM pasthist)
> >> > >
> >
> >
