Re: I try to convert guid to an integer for a new database
It depends what you want. You could use the hashCode() method to build an integer from the String guid. use as expression row1.GUID.hashCode() But please keep in mind an hashCode is not fully unique. If your GUID string has always nearly the same length it is very likely unique but if the guid has wide spread length, this will not work for a huge number of values.