I have a solution that needs to generate a unique barcode number, say 9 digits long. For my primary keys I use auto enter serial numbers, which might be a way to go, but they don't really need / want to be sequential as records are produced. Get (UUID) also isn't really an option as its too long and includes letters etc.
No two records could have the same number as it could present a problem when using the barcode to perform a find etc.
Any ideas welcome.