Re: question about stacking function calls in a where clause
From: Ed Prochak <edprochak_at_gmail.com>
Date: Sat, 28 Mar 2009 05:48:18 -0700 (PDT)
Message-ID: <72f19ff2-eaf5-4bf5-b609-d84bcbc48aa4_at_f37g2000vbf.googlegroups.com>
On Mar 27, 11:15 am, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
> On Mar 27, 9:48 am, Ed Prochak <edproc..._at_gmail.com> wrote:
>
> > 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??
>
> Good point! I just posted what my actual issue was - but you do point
> out a good point. That earlier mention of a regular expression
> function is sounding better and better.
>
> Then I might be able to say something like [' ]* for the match.
>
> Hmm.
>
> I really appreciate everyone's comments.
Date: Sat, 28 Mar 2009 05:48:18 -0700 (PDT)
Message-ID: <72f19ff2-eaf5-4bf5-b609-d84bcbc48aa4_at_f37g2000vbf.googlegroups.com>
On Mar 27, 11:15 am, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
> On Mar 27, 9:48 am, Ed Prochak <edproc..._at_gmail.com> wrote:
>
> > 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??
>
> Good point! I just posted what my actual issue was - but you do point
> out a good point. That earlier mention of a regular expression
> function is sounding better and better.
>
> Then I might be able to say something like [' ]* for the match.
>
> Hmm.
>
> I really appreciate everyone's comments.
And we really appreciate feedback, especially the grateful kind!!
Have a great day all!
Ed
Received on Sat Mar 28 2009 - 07:48:18 CDT