Hi DAW,

This bug still exist in DF18.1 (A3) - See original post

Issue exist in both dbSuggestionForm & cWebSuggestionForm

Basically, the SQLStrLike function needs to check whether DF_DRIVER_IGNORE_UCASE_SUPPORT is supported or not.

If ((IGNORE_UCASE_SUPPORT=False) and (pbCaseSensitive=False)) then it should produce a Like statement as per:

Code:
UPPER(File.Field) LIKE '%searchtext%'
where searchtext is uppercased

OR:
Code:
UPPER(File.Field) LIKE UPPER('%searchtext%')
Rather then the standard:

Code:
File.Field LIKE '%searchtext%'
Thanks