I have a question about SQL Server 2000 Full Text Index.

I want to create a catalog in a field (varchar(255)), but I?m with 2
problems:

1. The characters of this field can have accent. But when I do a search
I want to see the rows with and without the accent. For example:
        SELECT NAME
        FROM TABLE
        WHERE CONTAINS (FIELD, '"PLASTICO*"')

With this command I want to see the row PLASTICO and the row PL?STICO.

Is it possible? Now, I?m just receiving only the row PLASTICO. I need
that the catalog be accent insensitive. Can I do that?

2. My sencond problem is: I need to see also the rows that have the word
PLASTICO inside the complete word. For example: I want to see also the
rows with INTERPLASTICO, 2PLASTICO, XPTOPLASTICO. But whe I wrote the
following command I don?t receive these words:
        SELECT NAME
        FROM TABLE
        WHERE CONTAINS (FIELD, '"*PLASTICO*"')

Is it possible to do that? I wnat to see the rows that have the word
PLASTIC in the begin, middle or end of the words.

Thaks,

Paulo