Re: searchin for words with a "-"

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gerald Baeck (GeraldBaeck_at_discussions.microsoft.com)
Date: 11/14/04 

Date: Sun, 14 Nov 2004 11:54:08 -0800

Hi John,

thx for your answer. Here is my version:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)

"John Kane" schrieb:

> Gerald,
> Can you post the full output of -- SELECT @@version --? This is very helpful
> information to understand your environment BEFORE jumping to conclusions and
> solutions.
>
> However, based upon a quick test of a FTS query on "d-mail" (with and
> without the double quotes), I suspect that you have SQL Server (2000 or 7.0)
> installed on Windows Server 2004 (Win2003) or Windows XP (WinXP) as this
> type of FTS query results behavior is typical of the wordbreaker dll
> (langwbrk.dll) when used with punctuation characters such as "-" (dash or
> hyphen) and other such punctuation characters. This is not the typical
> behavior of SQL Server (either version) installed on Windows 2000 Server
> (Win2K) with its wordbreaker dll (infosoft.dll). See my many, many posts on
> this subject via Google Groups at
> http://groups.google.com/groups?q=langwrbk+infosoft
>
> Thanks,
> John
>
>
>
> "Gerald Baeck" <GeraldBaeck@discussions.microsoft.com> wrote in message
> news:87E770D9-617A-4C9A-A84E-BE239EE92E54@microsoft.com...
> > Hi,
> >
> > if I use the following SQL-Query:
> >
> > SELECT * from test_index
> > WHERE CONATINS(test_field, '"d-mail"')
> >
> > It seems that the query selects every row that contains the word "mail".
> >
> > How could I only serach for "d-mail"?
> >
> > thx, Gerald.
>
>
>

Relevant Pages

  • Sybase Connection String
    ... do you know the connection string for accessing a sybase DB from a Windows ... environment (more effective than odbc)? ...
    (microsoft.public.sqlserver.odbc)
  • RE: HELLPPP!! First time post and desperate
    ... basically i only needed to go to my host file in windows 32 and remove some ... ipconfig / renew and to first flush my dns cahces with ip config /flushdns ... and install sp2 but guess what even sp2 wouldn't install so here i am i am on ... is jilljordan2004@xxxxxxxxxxx thx jj ...
    (microsoft.public.windowsxp.general)
  • Re: Use cookies as authenticate under wince
    ... OK, thx for the information! ... of Windows CE, what device is it running on (it's a Windows Mobile device or ... I'am working on A Web-based interface that is runing at the HTTPD Server ... The server method I'm using is POST ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: [PHP] convert a string to integer
    ... thx a lot... ... taken as character and not a digit. ... Windows is a joke operating system. ... PHP General Mailing List ...
    (php.general)
  • Re: Win2k API "open file" dialogue box help
    ... >>whatever I'm opening.....small but very annoying problem when you have ... >> hope I'm in the right newsgroup, thx for any tips! ... >not asking a programming question but a Windows configuration question, ...
    (comp.programming)