I have a database where searching a text field for *N gives the same results as a search for *N*. I want to select records with with N as the last letter in that field but I am returned records with N anywhere.

I believe that this might have something to do with indexing since if I set the indexing language to Unicode the problem does not occur.

Are there any problems with doing this to the indexing or is there another way to solve the problem.

Thanks.

Try ==*N

Thanks, Genx. That gets round the problem.

I should perhaps have given more background. This database has recently been migrated from FM5.5 and the field in question holds data of the type 5/CS/01/H. FM5.5 seemed to treat this as one "word" whereas version 9 splits it up into four "words".

Further investigation has shown that a search for *N will find x/EN/x as well as x/EE/N but not x/NE/x or x/ENE/x.

I would be interested to know if there is a way to go back to the 5.5 behaviour, but if not, we will use your solution.

Well, you could search for */*/*/*N, but it would probably be better to split the data into separate fields.