Thanks for you're help Brian. That worked. I am now trying to show which IP's are used more than once, so I tried

select LEFT(127.0.0.1,len(127.0.0.1)-charindex('.',reverse(([Ip]))))

from tablename

group by 127.0.0.1

having count (127.0.0.1)>1

order by (127.0.0.1) desc

It does display the 127.0.0.1 's used more than once but it is also displaying some that are only used once. Any thoughts?