lpad

Tech

LPAD Ordering with decimals and varchar

Currently I’m trying to take a column from my database and trying to sort it so that the numbers that are in the column get ordered sequentially, and then the letters with numbers follow after. When I use the following statement SELECT * FROM term_size_ref WHERE 1=1 ORDER BY LPAD(term_size, 10000, ‘0’); I get the […]