On Nov 16, 2004, at 15:25, jda wrote: > select id,hit from thereferences where ((left(allFields, 6)='o'shea')) > order by id I assume you're escaping o'shea? Is capitalization an issue? -- Erik