Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
I have painted myself in a corner with indexing problem.
I index a field called - myfield -- which contains an alphabetized list of names
aname
bname
cname
Except in some of these entries there is a backslash at the start of the field
/aname
/bname
/cname
when I index on myfield it groups the backslashes first followed by the unbackslashes
/aname
/bname
/cname
aname
bname
cname
Is there a way to set up the index so the following progression occurs
/aname
aname
/bname
bname
/cname
cname
index on substr(myfield,2,12) doesn't do it obviously. I need code set up to skip over a /
I know some work arounds - like setting up a second field to handle the anomalies.
But would prefer a direct solution with a line of brilliant code. Or is this not possible.
many tnx
k
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement