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)
>> > >
>
>
