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 |
