I want to search for some text inside a field. This works great on other tables but it seems to work inconsistently.
I can search a 160,000 record table using the following SQL and it returns 35 records.
select * from MyTable where comments like '%doc%'
But in dbFront, it only returns 1 record. It looks like it can only find the text at the beginning of a field.
NOTE: I am not using the Full-Text search functionality.