Hi out there,

could anyone explain?

System: WinServer 2003 German
SQL Server 2003

SQL query on fulltext field which contains revision no. e.g. 10.02.0512

After setting the LCID to neutral (0) by SQL statement I got better results
than querying unter LCID German (1031). But one problem left:

i)
Select Field9,* from test.issues where contains(Field9,'"10.04.1*"')
result: 10.04.1nnn
OK

ii)
Select Field9,* from test.issues where contains(Field9,'"10.04*"')
result: 10.04 but not 10.04.nnnn

hhmmhh?
Why I don't get e.g 10.04.nnn under neutral LCID

Thanks for help beforehand,
Michael