In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE.
Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…