SQL: Number versus Character sorting
Table illustrating how numbers are sorted differently to character strings. The unexpected consequences of this are one of the reasons storing numbers as character strings is considered an SQL smell.
Making Sense of Information Technology
