>I need some advise on a search soultion.
>
>The user will put a specifc description of an item in the database(memo field).
>Example: BASEFRAME OFFSET F/R DBL 40.6
>Example: BASEFRAME F/R DBL 40.6
>Example: BASEFRAME F/R TPL 40.6
>
>Now I need to set up a search function that the user can type any part of the description or some combination and get the results.
>
>Any ideas?
Using ATC you can get a case sensitive position of a string. So try splitting the search string and doing an ATC on each word then ANDing or ORing the results as required.
HTH
Caroline