LIKE operator instead of INSTR
LIKE operator instead of INSTR
Is there a way to force the framework to use the like operator instead of instr when doing a contains, startswith or endswith? From my testing I found that the SQL generated by Devart (w/ instr) takes about 5 minutes to execute on my table, however when I run the same SQL using like instead of instr it takes about 2 seconds? From what I've read it looks like my only option is to create a stored proc, but by doing so I lose the ability to use Expression to dynamically build my where clause.