Once you create the function, it's really not that hard...

declare @dept varchar(200)

set @dept = 'A,B,C'

select item from [DelimitedSplit8K](@dept,',')

item

A

B

C

The article is by Jeff Moden (who had probably forgotten more about this stuff than I'll ever know).