I have a table with the primary key field populated with a text value AVF1, AVF2, AVF3 and so on, when I run a query to find the highest value it always returns AVF99 however I know there are higher values i.e. AVF200


how can I find the highest value in this field?