Search for a special character in sql server 2005

I have some special character in SQL Server 2005 on one of the field which has Japanese data. Due to which Cube processing fails with Attribute Key not found error.

The value interpreted by Analysis Services server is '野田　', but the value in db is 野田.

[Note the space after value '野田　']

Am trying to search for all the rows that contain this special character at end of the data in last_name column.

For this, I tried below query, but it doesnt give me the incorrect results.

select * from [#temp1]
where convert(nvarchar,last_name)  like convert(nvarchar,'%　') 

I want the rows that contains special character ('　') at end of values in last_name field.

What am I missing?