(1)
12.0.63.255---12000063255
12.6.223.255---12006223255
93.67.93.31---93067093031
12.0.63.255---12000063255
12.6.223.255---12006223255
93.67.93.31---93067093031
create FUNCTION f_SetIP(
@s varchar(8000)
)RETURNS bigint
AS
BEGIN
DECLARE @re varchar(3000)
set @re =''
WHILE CHARINDEX('.',@s)>0
BEGIN
set @re = @re + right(1000+LEFT(@s,CHARINDEX('.',@s)-1),3)
SET @s=STUFF(@s,1,CHARINDEX('.',@s),'')
END
set @re = @re+@s
return cast(@re as bigint)
END
GO
@s varchar(8000)
)RETURNS bigint
AS
BEGIN
DECLARE @re varchar(3000)
set @re =''
WHILE CHARINDEX('.',@s)>0
BEGIN
set @re = @re + right(1000+LEFT(@s,CHARINDEX('.',@s)-1),3)
SET @s=STUFF(@s,1,CHARINDEX('.',@s),'')
END
set @re = @re+@s
return cast(@re as bigint)
END
GO