AnsweredAssumed Answered

ExecuteSQL() exact word match

Question asked by mbraendle on Apr 18, 2013
Latest reply on Apr 19, 2013 by mbraendle

I'm trying to replicate the =word match in classic FileMaker Find by an ExecuteSQL() SELECT statement.

 

The only solution I have found so far for the WHERE part is

 

field LIKE 'word' OR field LIKE 'word %' OR field LIKE '% word' OR field LIKE '% word %'

 

Are there any simpler solutions?

 

A less wordy expression would be

 

field REXEXP '[[:<:]]word[[:>:]]'

 

but REGEXP is not supported by FileMaker.

Outcomes