--- Susan Russo <russo@morgan.harvard.edu> wrote:
> and accession like 'AY851043%'
I don't know if you've tried refactoring your query, but you could try:
AND accession BETWEEN 'AY8510430' AND 'AY8510439' -- where the last digit is
^ ^ -- lowest AND highest expected value
Regards,
Richard Broersma Jr.