Hi, I am in the process of writing some SQL to generate reports from Racktables. My question is how to I calculate the IP from the IP column. So example how to I get from 167908620 to 10.2.21.12? Thanks Cliff This message was created by: Cliff Lokkerbol - System Support Specialist - Innovation I.T Services "Simply put, it is possible to have convenience if you want to tolerate insecurity; but if you want security, you must be prepared for inconvenience." ________________________________________________________________________ Any opinions expressed in this email are those of the individual and not necessarily the company. The contents of this email and any attachments are confidential to The Innovation Group PLC and are solely for use by the intended recipient at the email address to which it has been addressed. This email and any attachments may not be disclosed to or used by anyone other than the intended recipient, nor may it be copied in any way. If you have received this email in error, please forward a copy of this email to itsupport@xxxxxxxxxxxxxxxxxxxxxxx and then delete it from your system. The Innovation Group PLC: Registered in England 3256771 Registered Office: Yarmouth House 1300 Parkway Solent Business Park Whiteley Hampshire PO15 7AE UK http://www.innovation-group.com This email and any attachments has been swept for computer viruses. Neither The Innovation Group PLC nor the sender accept any responsibility for computer viruses once this email has been transmitted.