Re: What is wrong with 'Weight'
From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 11/19/04
- Next message: Carl Henthorn: "2005 ft index help"
- Previous message: DMAC: "What is wrong with 'Weight'"
- In reply to: DMAC: "What is wrong with 'Weight'"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 09:07:21 -0500
too much weight is unhealthy:)
wrap it in double quotes. As a general practice it is wise to wrap all of
your search phrases in double quotes.
-- Hilary Cotter Looking for a SQL Server replication book? Now available for purchase at: http://www.nwsu.com/0974973602.html "DMAC" <drmcl@drmcl.free-online.co.uk> wrote in message news:462ac9a0.0411190329.44cfc0cb@posting.google.com... > Seems to be odd that this one word throws my update statement out. It > does work if I wrap it up in double quotes, but that means i need code > to cope with this on single exception, with no knowledge of which > other seemingly 'normal' word may cause my app grief. any clues? > > select * from table1 > where contains(shortdesc,'Weight') > > Syntax error occurred near 'Weight'. Expected '_NOT, '(', _ISABOUT, > _FORMSOF, _STRING, _PREFIX_STRING, '!'' > in search condition 'Weight'.
- Next message: Carl Henthorn: "2005 ft index help"
- Previous message: DMAC: "What is wrong with 'Weight'"
- In reply to: DMAC: "What is wrong with 'Weight'"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
