Hey kshah008! Nope, the issue remains. I just can't seem to get this MID function figured out. Creating a CASE scenario doesn't make sense, because the verbiage following the colon (Accident: Fall) is dynamic. I'm not a SQL Jedi, so that doesn't help the situation. ? Thanks for following up!