Esmerlin.sql

Select *, stuff(rango, 1, PATINDEX('%[0-9]%',Rango)-1, '') as Rango_Bonito
from Prueba p
INNER JOIN 
(
Select IdCliente,  
MAX(CAST(SUBSTRING(stuff(rango, 1, PATINDEX('%[0-9]%',Rango)-1, ''), 0, PATINDEX('%[^0-9]%', stuff(rango, 1, PATINDEX('%[0-9]%',Rango)-1, ''))) AS INT)) as algo3
from Prueba
GROUP BY IdCliente
) t
on p.IdCliente = t.IdCliente and p.Rango like '%' + cast(t.algo3 as nvarchar) + '%'