I would like to make some of our database search functions more sophisticated, but I'm running into a roadblock. The code below is a cleaned-up version of what I've come up with (minus several search ...

I was told to put everything in stored procedures for security reasons and anything that needed to be done to the procedures could be done on the SQL server and I wouldn't have to change anything in ...