It would seem that my database has unseen garbage in the field being queried.
On further testing I find that
select *
from people
where peopcode LIKE 'AB%AH%'
order by peopcode;
works, however
select *
from people
where peopcode LIKE 'AB%AH'
order by peopcode;
does not. I do have nine records that meet the above criteria and are found
if the pattern ends with '%' but not without it.