Ip截取

CREATE function getIp3 (@ip varchar(300),@count int )
RETURNS varchar(255)
AS
BEGIN
declare @Index int
declare @Part varchar(6)

select @Index=CHARINDEX('.',@ip)
declare @n int
select @n=0

WHILE (@Index> 0 and @n<@count)
begin
select @Part=substring(@ip,1,@Index-1)

select @ip=substring(@ip,@Index+1,len(@ip))
select @Index=CHARINDEX('.',@ip)
select @n=@n+1

end

if(@n+1=@count)
begin
return @ip
end

if(@n+1<@count and @Index=0)
begin
return null
end

return(@Part)

end
--select dbo.getIp3('192.168.10.12',2)