--1.不包含字母 SELECT * FROM t WHERE str NOT LIKE ‘%[a-zA-Z]%‘ SELECT * FROM t WHERE patindex(‘%[a-zA-Z]%‘,str) =0 --2.不包含汉字 SELECT * FROM t WHERE str NOT LIKE ‘%[吖-座]%‘ SELECT * FROM t WHERE patindex(‘%[吖-座]%‘,str) =0
原文：https://www.cnblogs.com/xiaonangua/p/10717890.html