Home Forums SQL Server 2005 SQL Server 2005 Strategies Datatype for IP addresses RE: Datatype for IP addresses
Steve Jones - SSC Editor
SSC Guru
Points: 734449
More actions
December 5, 2009 at 6:53 pm
#1088214
I'm with Jeff. I like them in separate fields, and then assemble them in another field if needed. As numerics they sort well, and the separation to me makes it easy to read when you're looking at the data.