Robert,

> I have already established with Jason that Full Text Search is not capable
> of search lists of codes ie.
>
> BARCODE
>
> 09938383908283
> 88388237898239
> 38472387823723
> 73924983478932
>
>
> User then types in "932"
> the search should return the bottom code.
>
> However because of the way Full Text Search works it treats codes
> differently to actual words.

As I said before, in order to have fast Full Text Searching as it appears
you want you need to override the event to generate the word list for each
entry such that it does the following:

(I'm assuming you won't trigger a search with fewer than 3 digits)

Text to search:

123456

Words generated:
123
234
345
456
1234
2345
3456
12345
23456
123456

Once the index has all of the possible combinations of unique words in it
then when a user types in a search it will find it against a straight index
of your word table.

Does this make sense?

Regards,
Jason LeRoy Wharton