Special Characters

A very simple question about the difference in behaviour between 2000 and
2005 fti:

the following search in a parts catalog works in SQLServer 2000

select count(1)
from dbo.partsdescription
where contains(*,'15"')

but returns Msg 7630 syntax error near '"' in the full-text search condition
'15"'

What exactly has changed to cause this error and is there a workaround?

Thank you for your help

The parser was less strict in SQL 2000. It seems you have stumbled across a
sequence that works. The work around would be strip non-alphanumeric
characters from the end of your search string.


--
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

"dvc" <dvc.DeleteThis@discussions.microsoft.com> wrote in message
news:25EB86A7-9FEF-43E1-B404-618217B944F4@microsoft.com...
>A very simple question about the difference in behaviour between 2000 and
> 2005 fti:
>
> the following search in a parts catalog works in SQLServer 2000
>
> select count(1)
> from dbo.partsdescription
> where contains(*,'15"')
>
> but returns Msg 7630 syntax error near '"' in the full-text search
> condition
> '15"'
>
> What exactly has changed to cause this error and is there a workaround?
>
> Thank you for your help
>
>