The problem is that I need to compare two fields of different types in a SOQL query.
TextField is a Picklist (so really text) and IntField is a Number(2, 0). Changing the types of these fields is not possible.
I would like to write SOQL like:
SELECT Id FROM SomeObject__c
WHERE Cast(TextField as Integer) > IntField
Cast(TextField as Integer) does NOT work.
Any advice on type conversion within SOQL. The normal APEX functions (e.g. integer.valueof) don't seem to be of any help here.