Innerjoin coma seperated values in sql server 2005

I have a table coloum with comma seperated values

Stateids CountryId 1,2,3,4 1 1,2 2

All these stateids have a statename in the corresponding statetable. Statetable also have a coloum named country id(or the purpose of join) I need all the statenames as below

Stateids CountryId Statename 1,2,3,4 1 andra,kerala,tamilnadu,karnataka 1,2 2 state1,state2

Thanks