• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

FullText Search - SQL Server

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    #41
    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

    Comment


      #42
      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.
      Originally posted by fannyadams View Post
      That's the opposite of what you said

      What's syntax are you using for your wildcard match?
      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.
      Knock first as I might be balancing my chakras.

      Comment


        #43
        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


        The Chunt of Chunts.

        Comment


          #44
          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

          Comment


            #45
            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/

            Comment


              #46
              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

              Comment


                #47
                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.
                Knock first as I might be balancing my chakras.

                Comment


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

                  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

                  Comment

                  Working...
                  X