Re: [firebird-support] What key word specifies a search for an entire word?

[Richard Damon rich...@damon-family.org [firebird-support]]

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 scan. Why not just use WHERE fstName = @po

-- 
Richard Damon