The SQL Server lookup field contains Chinese characters

/***************************************************************
%%
Percent percent Description: whether the SQL statement query field contains percent of Chinese characters
****************************************************************
Percent write:[email protected] 2007-12-17
Percent of a note: if there is reprint, please specify to place Http://blog.sina.com.cn/houkuan
**************************************************************

A: Is the first character in the query field?

SELECT * FROM table name where ASCII (field) >127

Second: Does the query field contain Chinese characters (any bit)?

SELECT * from table name where field like '%[acridine-Block]% '

--This can be used to determine whether to include Chinese characters rather than other double-byte characters

----[acridine-seat] is the Chinese character set the first to the last range, although the match is accurate, but the efficiency is very low with like

The SQL Server lookup field contains Chinese characters