Thanks,
I'm trying to use:
assume tablename = tblIPs
assume columname = IP
select
SUBSTRING(IP, charindex('.', IP)+1, len(IP) - charindex('.', IP) - charindex('.', reverse(IP)))
FROM tblIPs
BUT it leaves an extra . at the end of the ip address.
How can I structure the select statement to...