• A new one on me too, I would probably have ended up with really messy instr and substr or perhaps xpath functions to achieve the same.

    There is an interesting example of use of PARSENAME with IP addresses which shows a practical application: http://www.sql-server-helper.com/tips/sort-ip-address.aspx