I stumbled across a very nice repurposing of the PARSENAME function in SQL Server recently while playing around with some GeoIP Data. In SQL Server, the PARSENAME function is used for working with fully qualified server objects. e.g. a table on a linked server (‘LinkedServerName . Databasename . Ownername . TableName’). But PARSENAME can be …