I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...

SUBSTRING(full_name, CHARINDEX(' ', full_name) +1, LEN(full_name)) AS LastName, UPPER(LEFT(SUBSTRING(full_name, CHARINDEX(' ', full_name) +1, LEN(full_name)), 1)) AS ...

set @section_1 = ltrim(rtrim(left(@full_name,charindex(',',@full_name)-1))); set @section_2 = ltrim(substring(@full_name, set @first_name = left(ltrim(rtrim(@section ...