Help Me With a Simple PL/SQL Request Please !!

From: Charlotte Hurley <firas3_16_at_yahoo.com>
Date: Sun, 01 Apr 2001 05:35:54 -0400
Message-ID: <kitdcts6cqpvqael26jasdhdjnnc0f4c2b@4ax.com>

Hello Everyone,

        Has anyone developed a PL/SQL procedure/function used to return a search result from a table ?. Consider the following table :

Table : MEMBER_CONTACT

Fields: CONTACT_ID

	ORGANIZATION_ID
	FIRST_NAME
	LAST_NAME
	TITLE
	EMAIL_ADDRESS
	CITY
	STATE
	COUNTRY
	
	
	I would like to make a procedure/function that would take in

the last_name as an input parameter, and return all the users in this table matching the surname. Does anyone know what is the most efficient way to do this ? I can only return one record as a result so far, but does anyone know how to make the procedure return multiple records for possible matches based on the surname ? (in an efficient way). Any help would be greatly appreciated, thank you in advance.

Kind Regards,
Charlotte Hurley,
firas3_16_at_yahoo.com Received on Sun Apr 01 2001 - 04:35:54 CDT