0

I have one IP address, And I wanted to verify by passing this IP address to SQL Server table, where the SQL Sever table has two columns with start and end range of IP addresses. If I pass the IP address to the query it should check the given ip address is in the table and return the complete row.

Shri
  • 149
  • 1
  • 1
  • 15
  • 4
    show your table schema , a proper data sample, the expected . result ...and the code that you tried to write – ScaisEdge Oct 17 '16 at 13:08
  • 1
    also tag the version you are using – TheGameiswar Oct 17 '16 at 13:10
  • 2
    http://stackoverflow.com/questions/1385552/datatype-for-storing-ip-address-in-sql-server convert it to binary then do the compare. or see this answer: http://stackoverflow.com/questions/36177404/select-record-between-two-ip-ranges – xQbert Oct 17 '16 at 13:12
  • Thanks for replied. It looks I found the answer here http://stackoverflow.com/questions/33717815/how-to-compare-ip-addresses-in-sql-server – Shri Oct 18 '16 at 05:40

0 Answers0