I've discovered PARSENAME function as a good choice to order IP address stored in Database. Here there is an example.
My issue is I'm using Hibernate with named queries in a xml mapping file and I am trying to avoid the use of
session.createSQLQuery(..)
function.
I'm wondering if exists any PARSENAME equivalent function for HQL queries. I'm searching for it and cannot find anything.
Many thanks.