+ 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,678
    Thanks (Given)
    334
    Thanks (Received)
    587
    Likes (Given)
    2210
    Likes (Received)
    2630

    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,965
    Thanks (Given)
    177
    Thanks (Received)
    208
    Likes (Given)
    742
    Likes (Received)
    713

    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.
    Embrace your inner weird.

  3. #43

    Double Godlike!


    Join Date
    Dec 2012
    Posts
    10,384
    Thanks (Given)
    755
    Thanks (Received)
    742
    Likes (Given)
    4942
    Likes (Received)
    2860

    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,678
    Thanks (Given)
    334
    Thanks (Received)
    587
    Likes (Given)
    2210
    Likes (Received)
    2630

    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
    64
    Thanks (Given)
    2
    Thanks (Received)
    3
    Likes (Given)
    26
    Likes (Received)
    10

    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
    35,838
    Thanks (Given)
    369
    Thanks (Received)
    1233
    Likes (Given)
    3564
    Likes (Received)
    3088

    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.
    Best Forum Advisor, 2014
    Work in the public sector? You can read my FAQ here
    Click here to get 15% off your first year's IPSE membership

  7. #47

    Potty-trained

    suityou01's Avatar
    Join Date
    Jan 2009
    Location
    Skid row
    Posts
    20,965
    Thanks (Given)
    177
    Thanks (Received)
    208
    Likes (Given)
    742
    Likes (Received)
    713

    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.
    Embrace your inner weird.

  8. #48

    Faqqed Off

    TheFaQQer's Avatar
    Join Date
    Oct 2006
    Posts
    35,838
    Thanks (Given)
    369
    Thanks (Received)
    1233
    Likes (Given)
    3564
    Likes (Received)
    3088

    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
    Best Forum Advisor, 2014
    Work in the public sector? You can read my FAQ here
    Click here to get 15% off your first year's IPSE membership

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