I thought I finally had the cases figured out :( but now I know different. I using this statement in a subquery, but I've got an error message about the = sign Hoping someone can spot the error for me.

Thanks
Kirk

case meetings.AdmitTypeID
  when isnull((SELECT  dbo.ctAdmissionType.InOrOut 
	FROM   dbo.meetings m INNER JOIN  
	dbo.ctAdmissionType ON m.AdmitTypeID = dbo.ctAdmissionType.AdmitTypeID
	where m.meetingnumber=meetings.meetingnumber),0) = 1 then 'IN' else 'OUT' end as AdmitType