Thank you Bruce.

So, that means I would like help with T-Sql that will show me ID's with correct and incorrect IP Addresses.

For Example: tblIP

ID IPAdd

101 8.143.46.

102 8.243.6.AC

103 192.168.1.1

104 192.BC.168.1.1

105 192.212.456.21

So, I'd like help with something like this below:

SELECT ID

FROM IPAdd

WHERE (....code goes here that shows either the correct IPs or Incorrect IPs).

Thank you.