Re: Allowing the omission of 'AND'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Zark3,

You need to do it in your client code really.

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


Hi all,
Probably a complete FAQ/newbie question, but i'm not finding it (or
searching wrongly).
Suppose my user wants to do a search for two words, they want to do an
AND-search and they don't want to type in AND. i.e. 'John Smith'
should be 'John AND Smith' for CONTAINSTABLE to return any results,
but the user will type in 'John Smith' and expect to see both 'John
Smith' and 'Smith, John' (so no exact string matching, only AND-
connected search).
Is there a standard way to tell CONTAINSTABLE that it should connect
all separate words with AND?
TIA,
Chris


.

Relevant Pages

  • Re: Mail merge
    ... Assuming it's the same as in the PC environment, I'd have thought you could control the print paramters by setting up the paper source definitions in your mailmerge main document - before executing the merge. ... John, Smith, Jan, 10 ... > The merge involves a 2 page letter and pages for coupons. ...
    (microsoft.public.mac.office.excel)
  • Re: "Please tell me your name?"
    ... Smith being the family name and John the given name (= Christian ... They also often include grandparents' surnames as well: John Smith Jones Cooper Danks. ... I know someone who told me that he and his two brothers have three different surnames because they made different choices. ...
    (alt.usage.english)
  • Re: variant criteria name to filter
    ... The real problem I've had when cleaning data like this: ... John C. Smith ... The filter will look for John C Smith, and completely miss John C. Smith. ...
    (microsoft.public.excel.programming)
  • Re: YOU THINK I AM A SUCKER , John ( R ) Smith?
    ... Three kinds of qualities could be asserted to John Smith ... Luis Amaral Afonso ... his assertion that using HIS TABLE WE ARE able to get CONFIDENCE INTERVALS of the K-S TEXT .when the Population mean and std, ...
    (sci.stat.math)
  • Re: "Doctor Who" Matt Smith signs 5 year deal to play The Doctor
    ... whenjohn smith wrote in message ... wrote in message john ... you missed the "s" off it, or is that not a spelling mistake? ... NOT a spelling mistake like the OP ...
    (rec.arts.drwho)