Good afternoon,
I am creating a report in InfoAssist that shows bank numbers and branch numbers. In the program I used to use we had a function called Cast and we could sort those to columns in order. I am not sure what I need to do to have these sort in the right order. Using the Ascending function does not work like I want it to. Any ideas?

This message has been edited. Last edited by: <Kathryn Henning>,

Hi, can you give an example of what you're after as it is a little unclear. For example are you needing to split up a field into different sections so you can sort according to these? (eg sorting by the third and fourth digit of a 6 digit number rather than the whole number?)