Hello,
I'm using a 3 form input search form to return a result of Author names, example Name, FirstName and Title. I'm using a SP to search with these 3 inputs to return a recorset. Is using the Like with the '%' the best way to do so? What about if the fields are empty? Does someone have an example so that my SP is not too long?
Thank you,
Francis
I'm using a 3 form input search form to return a result of Author names, example Name, FirstName and Title. I'm using a SP to search with these 3 inputs to return a recorset. Is using the Like with the '%' the best way to do so? What about if the fields are empty? Does someone have an example so that my SP is not too long?
Thank you,
Francis