SQL Server determines whether a field contains Chinese/English characters/numbers

Because of the recent dirty data in the system, you need to query whether a field contains Chinese/English character/Number data.

Relatively simple, only this blog to do a simple summary, convenient for later review.

1. Determine if a field contains Chinese characters

SELECT  *  from     dbo. Channel_shopcommodityWHERE   =0and like        '  %[-block]%';

2. Determine if a field contains English characters

SELECT  *  from     dbo. Channel_shopcommodityWHERE   =0and like        '  %[a-z]%';

3. Determine if a field contains a number

SELECT  *  from     dbo. Channel_shopcommodityWHERE   =0and like        '  %[0-9]%';

SQL Server determines whether a field contains Chinese/English characters/numbers