On 12/2/19 5:06 AM, Tjioe Hian Pin thp_p...@yahoo.com [firebird-support]
wrote:
>
> what about:
>
> SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' '
> containing ' '||@po||' '
>
> Cheers,
> Tjioe
>
Again, that is likely prevent use of an index to find the record, and
force a table
what about:
SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' ' containing '
'||@po||' '
Cheers,Tjioe
On Saturday, November 30, 2019, 02:20:00 PM GMT+7, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 29-11-2019 22:52, Clyde Eisenbeis cte...@gmail.com
Mark, You're right. My brain was asleep. I've been using OR. Had never
tried AND.
Karol, Thanks for clarifying.
On Sat, Nov 30, 2019 at 5:10 AM Karol Bieniaszewski
liviusliv...@poczta.onet.pl [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
>
>>Not sure what pattern is.
Pattern replace unknown leter(s) sumbols are „%” multiple letters, „_” single
letter
e.g.
‘Ne%flix’ will find Neflix, Netflix, Netflix ….
>>I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are there
>>advantages to using '='?
If you use like
On 29-11-2019 22:52, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> The fstName is the column title, not the value. I'm using embedded
> Firebird.
That you're using Firebird Embedded doesn't matter, it works exactly the
same as Firebird Server for queries. The problem is that
The fstName is the column title, not the value. I'm using embedded
Firebird.
On Fri, Nov 29, 2019 at 3:48 PM Richard Damon rich...@damon-family.org
[firebird-support] wrote:
>
>
> On 11/29/19 4:32 PM, Clyde Eisenbeis cte...@gmail.com [firebird-support]
> wrote:
> >
> > Not sure what pattern
On 11/29/19 4:32 PM, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
>
> Not sure what pattern is. If I am searching for two words I use OR or
> AND.
>
> "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower(
> @p0 ) AND lower(fstName) LIKE lower( @p1 ) "
>
> I
Not sure what pattern is. If I am searching for two words I use OR or
AND.
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0
) AND lower(fstName) LIKE lower( @p1 ) "
I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are
there advantages to using '='?
Do you use pattern or simple string?
If it is simple string then better is using „=” instead of like.
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) = lower( @p0 )"
Regards,
Karol Bieniaszewski
Changing this
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower('%'
|| @p0 || '%')"
to this
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0
)"
works!
On Fri, Nov 29, 2019 at 12:53 AM Kjell Rilbe
Den 2019-11-28 kl. 17:30, skrev cte...@gmail.com [firebird-support]:
> I have this:
>
> "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE
> lower('%' || @p0 || '%')"
>
> Assume fstName includes "Richard" and "Rich". If I search for "Rich"
> it finds both names.
>
> What do I
This works:
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0
)"
On Thu, Nov 28, 2019 at 11:09 AM Richard Damon rich...@damon-family.org
[firebird-support] wrote:
>
>
> On 11/28/19 11:30 AM, cte...@gmail.com [firebird-support] wrote:
> >
> > I have this:
> >
> >
On 11/28/19 11:30 AM, cte...@gmail.com [firebird-support] wrote:
>
> I have this:
>
> "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE
> lower('%' || @p0 || '%')"
>
> Assume fstName includes "Richard" and "Rich". If I search for "Rich"
> it finds both names.
>
> What do I modify
28.11.2019 17:30, cte...@gmail.com [firebird-support] wrote:
> What do I modify so it finds only "Rich"?
Use SIMILAR TO.
--
WBR, SD.
++
Visit
I have this:
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower('%' ||
@p0 || '%')"
Assume fstName includes "Richard" and "Rich". If I search for "Rich" it finds
both names.
What do I modify so it finds only "Rich"?
15 matches
Mail list logo