Jump to content
Sign in to follow this  
DrS

Wilcard search

Recommended Posts

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.

Share this post


Link to post
Share on other sites

Thanks, Genx. That gets round the problem. :B

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.