What is wrong with 'Weight'

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: DMAC (drmcl_at_drmcl.free-online.co.uk)
Date: 11/19/04 

Date: 19 Nov 2004 03:29:22 -0800

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

Relevant Pages

  • Re: What is wrong with Weight
    ... wrap it in double quotes. ... your search phrases in double quotes. ... > in search condition 'Weight'. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: *.lnk file format
    ... >>It appears that you can't pass parameters in a .lnk file, ... and wrap the argument in a second set. ... > The count includes the whole string (quotes, spaces, and all) - but I ...
    (microsoft.public.pocketpc.developer)
  • Re: *.lnk file format
    ... >It appears that you can't pass parameters in a .lnk file, ... and wrap the argument in a second set. ... The count includes the whole string (quotes, spaces, and all) - but I ...
    (microsoft.public.pocketpc.developer)
  • Re: Odd problem moving tunes from PC to Mac
    ... copying across fine now- odd. ... popular, they either just stop dead at their real size, or wrap around ...
    (uk.comp.sys.mac)
  • Re: Regex help
    ... you should loop through each short string array to count each string ... > array item's quotes number, the key point is to determine if the array's ... If it has odd number of quotes, mark it as start concatenate array ...
    (microsoft.public.dotnet.languages.csharp)