Re: question about stacking function calls in a where clause
From: Ed Prochak <edprochak_at_gmail.com>
Date: Fri, 27 Mar 2009 06:48:45 -0700 (PDT)
Message-ID: <48118a00-eda0-4ae1-8daa-021332af74be_at_l19g2000vba.googlegroups.com>
On Mar 27, 7:42 am, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
> I have a situation where I'm trying to compare information in two
> different columns in a where clause. The information in question are
> last names.
Date: Fri, 27 Mar 2009 06:48:45 -0700 (PDT)
Message-ID: <48118a00-eda0-4ae1-8daa-021332af74be_at_l19g2000vba.googlegroups.com>
On Mar 27, 7:42 am, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
> I have a situation where I'm trying to compare information in two
> different columns in a where clause. The information in question are
> last names.
A couple other comments:
> The where expression I am trying to get to work is
>
> (upper(table1.last_name,'''','_') not like table2.last_name)
UPPER() takes only one argument. This can't work. You should have gotten an error.
> Is there some other techniques needed for this type of thing?
last thought: white space
Is there trailing white space on either name?
Does the table2 'O MALLEY' value have one or two spaces between the O
and the M??
Ed Received on Fri Mar 27 2009 - 08:48:45 CDT