FullText Search - SQL Server
+ Reply to Thread
Page 5 of 5 FirstFirst ... 3 4 5
Posts 41 to 48 of 48
  1. #41

    Godlike


    Join Date
    Sep 2014
    Location
    Non-Event Horizon
    Posts
    8,704
    Thanks (Given)
    339
    Thanks (Received)
    588
    Likes (Given)
    2221
    Likes (Received)
    2638

    Default

    Quote Originally Posted by suityou01 View Post
    Yes but the wildcard doesn't work. I'm sure I mentioned this before.
    I've not recommended the bloody wildcard.

    I'm telling you that Attrn is not a natural stem from Att so you won't get a result, which is the correct behaviour.

    To get Attrn in your result set, you'd have to use like %Att% in your where clause instead.
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

  2. #42

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,969
    Thanks (Given)
    177
    Thanks (Received)
    212
    Likes (Given)
    745
    Likes (Received)
    716

    Default

    Quote Originally Posted by TheFaQQer View Post
    Because you either need a "*" wildcard or to include something extra like FORMSOF, INFLECTIONAL and / or FREETEXT rather than just CONTAINS.
    Quote Originally Posted by fannyadams View Post
    That's the opposite of what you said

    What's syntax are you using for your wildcard match?
    Quote Originally Posted by LondonManc View Post
    I've not recommended the bloody wildcard.

    I'm telling you that Attrn is not a natural stem from Att so you won't get a result, which is the correct behaviour.

    To get Attrn in your result set, you'd have to use like %Att% in your where clause instead.
    Sorry LM, no you didn't. Others did.

    I have read your link and understand what you are telling me, finally.
    Brillo invited me back.

  3. #43

    Double Godlike!


    Join Date
    Dec 2012
    Posts
    10,455
    Thanks (Given)
    767
    Thanks (Received)
    753
    Likes (Given)
    4986
    Likes (Received)
    2890

    Default

    Quote Originally Posted by suityou01 View Post
    Sorry LM, no you didn't. Others did.

    I have read your link and understand what you are telling me, finally.

    Penny....Finally.........Drops



  4. #44

    Godlike


    Join Date
    Sep 2014
    Location
    Non-Event Horizon
    Posts
    8,704
    Thanks (Given)
    339
    Thanks (Received)
    588
    Likes (Given)
    2221
    Likes (Received)
    2638

    Default

    Quote Originally Posted by suityou01 View Post
    Sorry LM, no you didn't. Others did.

    I have read your link and understand what you are telling me, finally.


    Finally.
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

  5. #45

    Still gathering requirements...


    Join Date
    Nov 2014
    Posts
    68
    Thanks (Given)
    2
    Thanks (Received)
    4
    Likes (Given)
    28
    Likes (Received)
    12

    Default

    Can you post the exact syntax you used for the wildcard? It should work. Did you have the double layer of quotes?

    https://blogs.msdn.microsoft.com/sql...l-text-search/

  6. #46

    Faqqed Off

    TheFaQQer's Avatar
    Join Date
    Oct 2006
    Posts
    36,115
    Thanks (Given)
    380
    Thanks (Received)
    1283
    Likes (Given)
    3689
    Likes (Received)
    3200

    Default

    Quote Originally Posted by suityou01 View Post
    Sorry LM, no you didn't. Others did.

    I have read your link and understand what you are telling me, finally.
    Are you aware that you need wildcard when searching for something that's not a stem?

    Since Att isn't a stem of Attrn, you need to use a wildcard.
    Work in the public sector? You can read my FAQ here
    Click here to get 15% off your first year's IPSE membership
    Monday 27th November 1230-1330: IPSE Update on the Autumn Budget for contractors. Register here.

  7. #47

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,969
    Thanks (Given)
    177
    Thanks (Received)
    212
    Likes (Given)
    745
    Likes (Received)
    716

    Default

    Quote Originally Posted by TheFaQQer View Post
    Are you aware that you need wildcard when searching for something that's not a stem?

    Since Att isn't a stem of Attrn, you need to use a wildcard.
    Ah yes, except wild cards did not work.
    Brillo invited me back.

  8. #48

    Faqqed Off

    TheFaQQer's Avatar
    Join Date
    Oct 2006
    Posts
    36,115
    Thanks (Given)
    380
    Thanks (Received)
    1283
    Likes (Given)
    3689
    Likes (Received)
    3200

    Default

    Quote Originally Posted by suityou01 View Post
    Ah yes, except wild cards did not work.
    Really? Because you said earlier that wildcards did work:

    Quote Originally Posted by suityou01 View Post
    I did actually mean
    Code:
    Like '%attrn'
    works
    Work in the public sector? You can read my FAQ here
    Click here to get 15% off your first year's IPSE membership
    Monday 27th November 1230-1330: IPSE Update on the Autumn Budget for contractors. Register here.

+ Reply to Thread
Page 5 of 5 FirstFirst ... 3 4 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.