select Services from dbo.Contract where ISNUMERIC(Services)=1 and (Services not like '%[^0-9]%' or charindex('.',Services)>1 ) and charindex('.',‘0’+Services)<>1
cast(Services as as numeric(12,2)) between 0 and 100
select Services from dbo.Contract where ISNUMERIC(Services)=1 and (Services not like '%[^0-9]%' or charindex('.',Services)>1 ) and charindex('.',Services)<>0
cast(Services as as numeric(12,2)) between 0 and 100