This command will create a field named addcount and populate it with the number of characters in the address field, and it will sort and put the highest number as the top
|
ALTER TABLE ALIAS() ADD COLUMN addcount Replace all addcount with PADL(ALLT(STR(LEN(ALLT(address)))),3,"0") Index on last descending tag mytag |
J.S., Newark, OHI wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.
