IPToNumber

declare @ipaddress varchar(20)
declare @IpNumber float

SET @ipaddress = '2.6.190.56'

set @IpNumber = 256 * 256 * 256 * CAST(PARSENAME(@ipaddress, 4) AS float)
    + 256 * 256 * CAST(PARSENAME(@ipaddress, 3) AS float)
    + 256 * CAST(PARSENAME(@ipaddress, 2) AS float)
    + CAST(PARSENAME(@ipaddress, 1) AS float)

SELECT @IpNumber As IpNumber