About consistency -- this search fails in an indexed text field: select id,hit from thereferences where ((left(allFields, 6)='o'shea')) order by id So I don't know how o'shea is actually being indexed. FWIW, searching for o or shea also fails. Jon