What's the best SELECT technique to use to grab all of the O'Brian's from the last name field. They could be stored as

O'Brian
OBrian
O Brian

We need to be able to allow the user to enter "Ob" in a text box and get people who's last name starts with "Ob", including all the variations on O'Brian. The same will apply with McDonald, Mc Donald...you get the picture.

Any ideas??