SELECT PARSENAME(URLip, 4),
PARSENAME(URLip, 3),
PARSENAME(URLip, 2)
PARSENAME(URLip, 1)
FROM dbo.tbl_IPs

IP= 87.234.235.236
Result
4=87
3=234
2=235
1=236