转自：https://blog.csdn.net/weixin_33912445/article/details/85986901

1.判断某个字段是否包含中文字符

SELECT  *
FROM    dbo.Channel_ShopCommodity
WHERE   Disabled = 0
        AND StoreCode LIKE '%[吖-座]%';

2.判断某个字段是否包含英文字符 

SELECT  *
FROM    dbo.Channel_ShopCommodity
WHERE   Disabled = 0
        AND StoreCode LIKE '%[a-z]%';

3.判断某个字段是否包含数字

SELECT  *
FROM    dbo.Channel_ShopCommodity
WHERE   Disabled = 0
        AND ShopCommodityName LIKE '%[0-9]%';