SELECT [AcademicYearID], [Address1], [CreatedDate], [DateOfBirth], [FirstForename], [HasNotes], [MobileTel], [NoOfCourses], [Pending], [RefNo], [Sex], [StudentDetailID], [Surname] FROM (SELECT [AcademicYearID], [Address1], [CreatedDate], [DateOfBirth], [FirstForename], [HasNotes], [MobileTel], [NoOfCourses], [Pending], [RefNo], [Sex], [StudentDetailID], [Surname] FROM (SELECT RTRIM([vSubStudentDetail].[AcademicYearID]) AS [AcademicYearID], [vSubStudentDetail].[Address1], [vSubStudentDetail].[CreatedDate], [vSubStudentDetail].[DateOfBirth], [vSubStudentDetail].[FirstForename], [vSubStudentDetail].[HasNotes], [vSubStudentDetail].[MobileTel], [vSubStudentDetail].[NoOfCourses], [vSubStudentDetail].[Pending], RTRIM([vSubStudentDetail].[RefNo]) AS [RefNo], RTRIM([vSubStudentDetail].[Sex]) AS [Sex], [vSubStudentDetail].[StudentDetailID], [vSubStudentDetail].[Surname] FROM [ProSolution].dbo.[vSubStudentDetail] AS [vSubStudentDetail]
) AS [vSubStudentDetail]) AS [vSubStudentDetail] WHERE ([AcademicYearID] = '07/08') AND ([RefNo] = '175878') ORDER BY [Surname] ASC, [FirstForename] ASC