Re: question about stacking function calls in a where clause
From: Larry W. Virden <lvirden_at_gmail.com>
Date: Fri, 27 Mar 2009 08:06:25 -0700 (PDT)
Message-ID: <22d209e3-14fe-474c-b61d-af0abafe1113_at_e3g2000vbe.googlegroups.com>
On Mar 27, 8:42 am, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
>
> The where expression I am trying to get to work is
>
> (upper(table1.last_name,'''','_') not like table2.last_name)
>
Date: Fri, 27 Mar 2009 08:06:25 -0700 (PDT)
Message-ID: <22d209e3-14fe-474c-b61d-af0abafe1113_at_e3g2000vbe.googlegroups.com>
On Mar 27, 8:42 am, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
>
> The where expression I am trying to get to work is
>
> (upper(table1.last_name,'''','_') not like table2.last_name)
>
Sorry - I mistakenly copied the wrong string there - the string that
does work, sort of, is:
(upper(table1.last_name) not like table2.last_name)
Received on Fri Mar 27 2009 - 10:06:25 CDT