Why does SELECT MAX(uuid) return A-22-999 when there is A-22-1000 in the database?

Question

SQL

Why does SELECT MAX(uuid) return A-22-999 when there is A-22-1000 in the database?
How to build the right query?

Answer 1

String comparison is character-by-character, without highlighting numeric parts. '9' > '1'.
You won't achieve anything by standard means here.