MSSql Scalar Function that converts an IPAddress to its Numerical equivalent.

IPAddress2IPNumber.sql

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		James Tryand
-- Create date: 2013-12-20
-- Description:	Converts An IPAddress to it's numerical equivalent
-- =============================================
CREATE FUNCTION IPAddress2IPNumber 
(
	@IPaddress varchar(20)
)
RETURNS bigint
AS
BEGIN
	RETURN
		16777216 * CAST(ParseName(@IPaddress, 1) as bigint) +
		65536 * CAST(ParseName(@IPaddress, 2) as bigint) +
		256 * CAST(ParseName(@IPaddress, 3) as bigint) +
		CAST(ParseName(@IPaddress, 4) as bigint)
END
GO