Department would be prefixed in this case.

Thanks All for taking time. Was using substring on charindex, let me know if there are better solutions.