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 |
M.S., Mt. Vernon, ILWe have over 200 vendors we work with on a daily basis and (the AccuZIP6 techs) are the most knowledgable, helpful group of folks I have worked with, always willing to go out of the way to help. As owner and GM of a Print and Mail Shop I admire the dedication these folks have in making sure we are satisfied. I also appreciate the fact that a human answers the phone.
