Cacher is the code snippet organizer for pro developers

 Case
			When IsNull(Gender.AnswerInteger, 0) = 1 Then 'Male'
			When IsNull(Gender.AnswerInteger, 0) = 2 Then 'Female'
			Else ' '
		 End As [Gender]

Case When attending.AnswerInteger & 2 = 2  Then 'Yes' Else 'No' End As [Attending IAAF]
,Case When attendingIPC.AnswerInteger & 1 = 1 Then 'Yes' Else 'No' End As [Attending IPC]