问使用SQL Like对一定范围的字符进行模式匹配

EN

where col like '__' or col_like '___' or . . .

where col like '__%'  and        -- at least two characters
      col not like '_________%'  -- not 9 characters

where len(col) between 2 and 10

where len(col) between 2 and 10 and
      col not like '%[^0-9]%'

DECLARE @TempField varchar(max)= '1v3Abc567'

DECLARE @FieldLength int = LEN(@TempField)
DECLARE @CountNumeric int = 0

WHILE @FieldLength > 0
BEGIN
SELECT @CountNumeric = @CountNumeric +  ISNUMERIC( SUBSTRING (@TempField,@FieldLength,1))
SET @FieldLength = @FieldLength - 1
END

SELECT @CountNumeric NumericCount

SELECT * FROM mytable WHERE mycol LIKE '%[0-9]{2,10}%';