Thank you for the example code. It was an interesting solution that got me moving in the right direction. It works well when the search string matches from the beginning of (or all the way to the end of) the database string. I'll probably use hv's solution for this particular project but I think I'll try and flesh out your solution a bit more so I have another option if needed. Thanks again for taking a look.