I've been given the task of consolidating call tables and am experiencing some problems.
Is there a SQL command I can use in Filter editor to convert CHAR to Integer "on the fly"? It's a wild and crazy question I know and the answer is probably no, but I need to look at all avenues.
I need to filter/split by Balance and the balance should be a number but is text. That's why I want to do the conversion.
The Application I am using has a call table structure where there are Date fileds and number fields that are formatted as CHAR e.g A ballance of £5000 is diplayed as 00000500000 (500000p)
Any one got any ideas, other than deactivating the appliaction and doing some backend work (which I think would cost us £££).