Sort text field leading zeroes
From: <vjp2.at_at_at.BioStrategist.dot.dot.com>
Date: Fri, 15 Mar 2019 23:27:38 +0000 (UTC)
Message-ID: <q6hcda$t6l$1_at_reader2.panix.com>
[Quoted] Ok, LPAD if it was a number, but I have a field "3 St" "40 St" and "500 St" and I want to ORDER them. I'm thinking extract the number, pad it then reappend? Is there an easier way?
Date: Fri, 15 Mar 2019 23:27:38 +0000 (UTC)
Message-ID: <q6hcda$t6l$1_at_reader2.panix.com>
[Quoted] Ok, LPAD if it was a number, but I have a field "3 St" "40 St" and "500 St" and I want to ORDER them. I'm thinking extract the number, pad it then reappend? Is there an easier way?
- = - Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com ---{Nothing herein constitutes advice. Everything fully disclaimed.}---