SQL Server 2008 R2: Check if IP address is in a range

[aconybeare]

Hi,

I'm trying to write a SP to check if a passed in IP address is in a range e.g. equal to or between a start and an end address. e.g. -

Is 10.10.10.5 equal to or between 10.10.10.1 and 10.10.10.10

Regards Al