How to compare value from the first column with value from second one

I have the following table:

id---name-------contry---states
1----usa,ab------usa------ab
2----alb,ac------alb------ac
3----nm----------bun------nm
4----but---------but------nt
5----rsa,ab------rsa------rb
6----Null--------brt------rt

I should take the value from column 'country' and 'states' and check that this values exist in the column 'name'. Show the rows where this values does not exist.(null or only country or only states)
for example: if in the 'country' i have value 'usa', in the column 'name' i already have this 'use' value THEN does not show me this row. Show me the rows where the value 'usa' does not exist. The same with column 'states'

What I have tried:

have no idea what o should try. I try through 'like' or 'declare' but can not find the logic. thank for helping

Tags: SQL, Oracle, SQL Server, SQL Server 2012