hi
is it possible to order a table by a partial string field value ?

column :
test1FIRSTVALUE
test2SECONDVALUE
test3ANOTHERVALUE

in this case i want this order :
test3ANOTHERVALUE
test1FIRSTVALUE
test2SECONDVALUE

the order should start from the 6th CHAR :

ANOTHERVALUE
FIRSTVALUE
SECONDVALUE

ignoring the first 5 chars : test1 , test2 , test3

thanks

Mauro
Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com