Page 1 of 1

Quick search for whole word

Posted: Fri May 12, 2023 5:08 pm
by raymondfung

Is there any way I can search for the result for whole word.

case like I am searching for "ARK" and I am looking for "ARK" but not including "Mark".

I know advance search with "=" can do this. May I know if quick search can do this too? like any regex option can be used? like "\b" ?


Re: Quick a whole word

Posted: Sat May 13, 2023 8:34 am
by MichaelG

SQL Server may support syntax like:

[CompanyName] LIKE '%[a-zA-Z]keyword[a-zA-Z]%'