I need to create a rule only for alphabet characters
i used the following Wildcard character sequences but didn't work !
开发者_开发知识库LIKE '[A-Za-z]'
LIKE 'a-z'
LIKE 'A-Za-z'
Double negative like
WHERE
  SomeCol NOT LIKE '%[^a-z]%'
Ignoring the first NOT, this means "match any character not in the range a to z".
Then, you reverse using the first NOT which means "don't match any character not in the range a to z"
Edit, after comment
LIKE '%[a-z]%' means "find any single character between a-z. So 111s222 is matched for example because s matches in this like.
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论