Originally posted by sfdba
where invno like '%parameter%';
with that there is no way you can use an index