Tim

Field content: 'Jose Eduardo Helminsky'

select * from table where textsearch('Eduardo' in field) -> work as expected

select * from table where textsearch('Edu' in field) -> don´t give me any
result

then

select * from table where field like '%Edu%' -> give me the what I want

No problems at all.
My doubt is if I have an indexed field, the use of LIKE operator will use it
?

Eduardo

Eduardo,

<< My doubt is if I have an indexed field, the use of LIKE operator will use
it ? >>

Not in DBISAM.  However, EDB will use an index for LIKE, even with multiple
wildcards like you indicate.

--
Tim Young
Elevate Software
www.elevatesoft.com