SQL Query Help on finding Extended ASCII

How can I ma开发者_Python百科ke a select statement to seaqrch for HI-ASCII characters for ex..chinese charatcres

Thanx

Here is a solution

just add N before any value you want to search for for example

select * from [Table] where [Name]like N'% 的 %'

N= for search extended ascii characters