Hi Sheena,
>When the user enters a name i.e. "o'keefe" if returns nothing and if they enter okeefe I get my data displayed, therefore it's too restrictive. I need my data to display if they enter o'keefe, okeefe
>or o keefe. Also I'd like it to display all data for names beginning with a particular letter.
Have a look at the SOUNDEX function. For example searching for all records with 'Okeefe' will return all the 3 records.
Info:
SOUNDEX( ) returns a four-character string. By comparing the results SOUNDEX( ) returns for two character expressions, you can determine if the two expressions are phonetically similar, indicating that they sound alike. SOUNDEX( ) isn’t case sensitive and generally disregards vowels.