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:
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.