>Dear Sirs,
>
>In FP25 if we index on any field it takes into account the symbols and does the indexing.
>
>e.g
>
>1) M.S.Agarwal
>2) M.A.Agarwal
>
>In the above example 2) should come before 1) but it remains as it is.
>
>If dots and space are removed then it works OK.
Then you can have an index expression that'd remove them :
index on chrtran(myField,'. ','') tag myField
But instead I'd suggest doing chrtran() operation in field's valid and have a regular :
index on myField tag myField (or upper(myField)
Cetin