>I have an application that needs a compound index built. The fields are all string fields, but the user would like the second field to be in descending order. Is there a good way to do this in VFP?
>
>TIA
How long is this field and what kind of information is in it? Are they only ASCII chars from A to Z? If so you may try
str = 'ABC'
NewStr = CHR(155-ASC(SUBSTR(upper(str),1,1)))+CHR(155-ASC(SUBSTR(upper(str),2,1)))+CHR(155-ASC(SUBSTR(upper(str),3,1)))
but this looks like a very complicated solution. I'm sure there is more elegant using bitshift operations...
If it's not broken, fix it until it is.
My Blog