title: Sort numbers with letters numerically and alphabetically
body: <p>I have a Database on my website with a Long List of #'s (Product #'s) all containing letters (Exp. TC-345, TC-234 or HC-236W 123-234-PWD...) </p>
  
  <p>Can we numerically and alphabetically sort the #'s on the website?</p>
  
  <p>Currently we store it alphabetically, so the order is (10-PDW, 100-PDW, 110-PDW 2-PDW)
  We would like to change it into (2-PDW, 10-PDW, 100-PDW, 110-PDW) </p>
  
  <p>My developers say "The colorway number can never be sorted numerically. We would need to add another numeric field to the database for all the colorways and then sort that field numerically. Right now those numbers are in alphabetical order." </p>
  
  <p>How do you sort a numbers with letters? We'd like to avoid adding a Numeric Field - that's just extra work. Is there any new technique out to do this?</p>