R:Base has always in effect strimed the data before comparisons. It has
been a great convenience. After all, the trailing characters are not
visible and one could enter one by accident. Very hard to know what has
trailing spaces and what has not. No brainer to me, ignore them by default.
Works really well unless you want to play data games and hacker roulette.
The few times over the years where R:Base's default behavior has been a
problem greatly outweighs all the coding I would have done to assure that
behavior most of the time.
-- Dennis McGrath
mailto:[EMAIL PROTECTED]
-- Productivity Tools for R:Base Programmers
http://www.enteract.com/~mcgrath/dennis
-- Full time consultant with:
SQL Resources Group
Steve Hartmann
Oak Park, IL
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bernie Corrigan
Sent: Monday, June 04, 2001 1:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Am I doing this right?
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)
>> > >
>
>
