One of the developer asked a question to handle and parse the IP Address data on a table, as you are aware IP Address data would have 4 sections and to parse each 4-part value is requried for reduce any duplication. You could take hlep of SUBSTRING and CHARINDEX statements in this case, but to just validate the data you can perform as follows: ...