Hi all and happy new year for everbody !

I have a problem for indexing a field ( clocation ) in a sql clause.
cf picture in the attachment please.


I should like "c:\datas\Data1" Before "c:\datas\Data1"

it 'is possible ?

SET ENGINEBEHAVIOR 90
SELECT DISTINCT  CAST( ADDBS( UPDATE.clocation ) AS C(50) ) AS clocation , UPDATE.iid ;
 FROM UPDATE WHERE FILE( ADDBS( UPDATE.clocation) + "Id.dbf") AND ;
 FILE( ADDBS(UPDATE.clocation) + "Compagny.dbf") AND ;
 FILE ( ADDBS(clocation) + "Amline.dbc" ) INTO ARRAY Societes
SET ENGINEBEHAVIOR 70

thank in advance for answer.


bernhart