Ignore that emoticon, I don't know how that got in there.  Supposed to be another right-paren.

Create a function that returns a table like so:

*********************

CREATE FUNCTION myuser.wildcard_search (@search_string varchar(50)) 

RETURNS @Result TABLE

 (

 title varchar(200),

 author_name varchar(200)

&nbsp

BEGIN

declare @title varchar(80)

declare @author varchar(200)

declare...

I was overcomplicating it.  I ended up using a user-defined function that returned a table, and calling that from within a cursor.  I have an Oracle background, and so I didn't...