Create a second field in the table which holds the last name without puncuation.. Have an insert,update trigger that populates that field without punculation... then use the where against that field instead of the display name field which of course you only use to display the value.

>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??