| Subject | What key word specifies a search for an entire word? |
|---|---|
| Author | |
| Post date | 2019-11-28T16:30:41Z |
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"?