I am using SQL Server 2008. I would like a stored procedure for client lookup purposes. Attached is a text document giving details and table structures. I realize that nearly every application has a similar lookup procedure so I am looking for standard coding, best practices, etc.
Name lookups should be able to handle apostraphes: "O'Connell", also hyphenated names like "Smith-Jones"
Thank you so much for your consideration.