contains(t 3) or contains(??)

Hi,
I am sure that my question was posted before but cannot find anything. So
here it is again:
1. Is there a way to search for "T 3" or "?" using contains without
changing the noise-text file?
2. No kind of escape character for the space in "T 3"?
Any help is really appreciated!
Thanks, Andreas
Andreas,
Unfortunately, no as the SQL Server/MSSearch wordbreaker does not allow
customization of wordbreaking characters.
If the search characters are anything except single letters &/or single
digit numbers, you can of course use a search phrase, i.e., multiple words
contained within double quotes.
Is your concern the ability to search on multiple single letters/digits
without getting error msg 7619" "The query contained only ignored words"?
Regards,
John
"Andreas" <nospam@.nospam.com> wrote in message
news:uZ6Ss07eEHA.3428@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am sure that my question was posted before but cannot find anything. So
> here it is again:
> 1. Is there a way to search for "T 3" or "?" using contains without
> changing the noise-text file?
> 2. No kind of escape character for the space in "T 3"?
> Any help is really appreciated!
> Thanks, Andreas
>
|||Completely right. There are some data in the database with names like "T 3"
or "M I B". The contains ('"T 3"') or contains ('"M I B"') gives exactly
7619 error msg. Any workarounds?
Thanks, Andreas
"John Kane" <jt-kane@.comcast.net> schrieb im Newsbeitrag
news:uVdDKT8eEHA.704@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Andreas,
> Unfortunately, no as the SQL Server/MSSearch wordbreaker does not allow
> customization of wordbreaking characters.
> If the search characters are anything except single letters &/or single
> digit numbers, you can of course use a search phrase, i.e., multiple words
> contained within double quotes.
> Is your concern the ability to search on multiple single letters/digits
> without getting error msg 7619" "The query contained only ignored words"?
> Regards,
> John
>
> "Andreas" <nospam@.nospam.com> wrote in message
> news:uZ6Ss07eEHA.3428@.TK2MSFTNGP11.phx.gbl...
So
>
|||You're welcome, Andreas,
One possible solution, depending upon the OS platform you have SQL Server
installed on (post @.@.version), and how you display the film titles to your
users, is to embed html tags next to or touching or in contact with the
leading & trailing single letters, such as <b>M I B<\b> as this could solve
you problem with Win2K. If you're using WinXP or Win2003, this solution will
not work, and I'd recommend adding a special keyword or phrase to search on
for these known single letter movie titles, such as MIB or T3 and capture
these special single letter combinations when imputed from the searcher.
Also, if you want you can email me for non-MSSearch solutions as I have
developed some FTS solutions (using a movie database too) for a book project
I've researched & developed over the past 2 years...
Thanks,
John
"Andreas" <nospam@.nospam.com> wrote in message
news:uXNB7mRfEHA.236@.tk2msftngp13.phx.gbl...
> Completely right. There are some data in the database with names like "T
3"[vbcol=seagreen]
> or "M I B". The contains ('"T 3"') or contains ('"M I B"') gives exactly
> 7619 error msg. Any workarounds?
> Thanks, Andreas
>
>
> "John Kane" <jt-kane@.comcast.net> schrieb im Newsbeitrag
> news:uVdDKT8eEHA.704@.TK2MSFTNGP09.phx.gbl...
words[vbcol=seagreen]
words"?
> So
>
|||Hi John
I sent you an email to jt-kane@.comcast.net - can you please let me know if
you got it ... I thought it would be better to continue our conversation
there.
Regards
Andreas
"John Kane" <jt-kane@.comcast.net> schrieb im Newsbeitrag
news:OHZpXncfEHA.644@.tk2msftngp13.phx.gbl...
> You're welcome, Andreas,
> One possible solution, depending upon the OS platform you have SQL Server
> installed on (post @.@.version), and how you display the film titles to your
> users, is to embed html tags next to or touching or in contact with the
> leading & trailing single letters, such as <b>M I B<\b> as this could
solve
> you problem with Win2K. If you're using WinXP or Win2003, this solution
will
> not work, and I'd recommend adding a special keyword or phrase to search
on
> for these known single letter movie titles, such as MIB or T3 and capture
> these special single letter combinations when imputed from the searcher.
> Also, if you want you can email me for non-MSSearch solutions as I have
> developed some FTS solutions (using a movie database too) for a book
project[vbcol=seagreen]
> I've researched & developed over the past 2 years...
> Thanks,
> John
>
> "Andreas" <nospam@.nospam.com> wrote in message
> news:uXNB7mRfEHA.236@.tk2msftngp13.phx.gbl...
> 3"
allow[vbcol=seagreen]
single[vbcol=seagreen]
> words
letters/digits[vbcol=seagreen]
> words"?
anything.[vbcol=seagreen]
without
>