ExecuteSQL finding single words

Discussion created by Polarpro on Dec 13, 2015
Latest reply on Dec 18, 2015 by Extensitech



I wonder if there is a possibility when using ExecuteSQL to search for single words in a field like we know it from FileMaker. When searching for 'def' I would like to be able to find records that have for example 'abc def', 'abc-def', 'abc/def' in a field (without having to write long queries that contain things like  ...LIKE lower('%-def%')...  


Thanks a lot