SPONSORSHIPOPPORTUNITYCHILD

Stores child sponsorship opportunities.

For the full definition of the SPONSORSHIPOPPORTUNITYCHILD table, see SPONSORSHIPOPPORTUNITYCHILD.

Fields

Field	Change	Field Type	Null	Notes	Description
NAME	Changed	nvarchar(154) (Computed)	yes	CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + LASTNAME	Returns the child name (First + Middle Initial + Last (individuals)).Expression changed from CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + LASTNAME to CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + LASTNAME