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 so it finds only "Rich"?
if you only want the case that fstName is exactly Rich, then don't use like but use equals (=) If you want Rich as part of the string but not Richard, what is allowed before/after Rich that makes it a 'word'? -- Richard Damon