Pardon me if this has been answered already but I am having difficulties sorting files according to one field that we use quite regularly. The field contains numbers sometimes with a letter and hyphen prefix (like G-123).
If I try to sort the numbers 1, 10, 11 and 101 the sorted return is 1, 10, 101, 11. I'm a new FM user on the create side but I am using someones old templates and dont want to make a global mess. Any help would be greatly appreciated,