SELECT with where between not working as expected
A shorter answer:
... WHERE MID(server, 2) BETWEEN 89 AND 110

Or, if you need to limit to the &quot;C&quot; set of servers:
... WHERE MID(server, 2) BETWEEN 89 AND 110
      AND server LIKE &quot;C%&quot;

Or (to avoid trouble with &quot;24H1&quot;),
... WHERE IF(server LIKE &quot;C%&quot;, 
             MID(server, 2) BETWEEN 89 AND 110,
             FALSE)

Oh, now I see another 'bad' server name (INT1).  Face it, you need to put some of the burden on the DBA.  He must realize that the practical way is to say
... WHERE server BETWEEN 'C89'  AND 'C99'
       OR server BETWEEN 'C100' AND 'C110'

That is, break up the filtering into as many ranges as needed so that string comparisons will work, and do not think numeric.