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.V., Brentwood, TNI just want to take a moment and let the folks at Accuzip know what great support I have received from Mathew Little. He has really helped get our IMB Barcode project off the ground! Learning Accuzip has been a pleasant process and the relief of knowing my project will be installed despite the tight deadline is wonderful! I wish there were more like you doing support at other companies when we need them.
