>I know I have seen some stuff on here before about this but wasn't paying attention then. I have a contact table with fields for both the first namd and last name plus others of course. I have a form where I want to enter a name and search for all records that this name is LIKE either the first name of the last name. I am using stored procedures. How do I write a stored procedure that would check either first name or last name and return any records that are like those names?
>
>A name entry could be "win" and I would want to find "Winsborough" in the last name column.
>Thanks for any help.
>Tim
You may also read this excellent article about dynamic search
http://www.sommarskog.se/dyn-search-2008.html (It is a bit long, but well worth it).
If it's not broken, fix it until it is.
My Blog