I am bringing a table into Access through ODBC. There is a text field with numbers, some numbers with a dash and possibly a letter e.g., 6406-24, 6406-3, 6406-1T. I would like to sort these as 6406-3, 6406-24 and 6406-1T. Can any one come up with a way to do this? Thanks.