How to query Unicode characters from SQL Server 2008

With NVARCHAR data type, I store my local language text in a column. I face a problem how to query that value from the database.

• ዜናገብርኤልስ is stored value.

I wrote SQL like this

select DivisionName 
from t_Et_Divisions 
where DivisionName = 'ዜናገብርኤልስ'

select unicode (DivisionName) 
from t_Et_Divisions 
where DivisionName = 'ዜናገብርኤልስ'

The above didn't work. Does anyone have any ideas how to fix it?

Thanks!

via Chebli Mohamed