Kirsten,
Could you post the full output of the following SQL code? This will help me
gather info on your environment and help provide more direct and faster
answers.

use <your_database_name_here>
go
SELECT @@language
SELECT @@version
-- will need to set 'show advance options' first...
sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

Are the words or phrases that you expect are the accented words? For
example, cafe vs. Café (note, the accent on the e).
If so, you should bear in mind that SQL Server 2000 is not accent sensitive,
i.e.. accent in-sensitive and that this is fixed only in SQL Server 2005.

If not, do you get the expected results if you alter the CONTAINS query and
not reference the "tablename.columnname", for example:

select Nombre from insumos
where CONTAINS(Nombre, '"vase*"')


Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


[quoted text, click to view]

I have a fulltext index on the "INSUMOS" table with the following options:

1) Default language is spanish
2) The NOISE.ESN is empty (i.e. index everything)
3) The catalog is updated

If I run the following query I don't get the expected results:

select Nombre from insumos
where CONTAINS(Insumos.Nombre, '"vase*"')

I get:

Valvula hidrocefalia presion baja
Vaselina solida pote Env x 200 grs
Otros varios
Varios
Especulo vaginal mediano 32-120-02

Why is this happening? Any ideas?
Thanks!

5 rows. And yes: "Vaselina" is supposed to match but not the others.
Thanks!

[quoted text, click to view]

Is this one or 4 rows? Vaselina is a match to the wildcarded vase.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]