Matching Part of a Word in a SQL Query

Hi I am in a bit of a crunch on this SQL query here so I appreciate any help.

Lets say I have this part:

HON787800F015

I need to find all parts that match above up to the F but then have an R after. For example one of the results that would match would look like this:

select * from inv_master (nolock) where part_no like 'HON787800R%'

I appreciate any help you might be able to offer

Thank you much.