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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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