Support 805.461.7300
Sales
Our Technology. Your Success.

Count Characters in a Field

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

« Back to Commands

I was looking for an easy to use all-in-one postal software solution and was working with Satori Software. They quoted me $10,000.00 which was out of the realm of our budget. I was also lead to believe that they were the only solution, until I found Accuzip. I was able to save my company over $9,000.00 with one phone call to your courteous and knowledgeable sales staff. Your product does everything that we need and much much more. Thank you Accuzip!
J.S., Newark, OH