Professional Web Applications Themes

Complete word queries? - Microsoft SQL / MS SQL Server

I am trying to create a query that searches for key words in text fields for a web based helpdesk application. Currently I am using the like operator but if I do a search on problems with ACT (a contact management app) if will find all cases with those letters in the history. Example below: Select * from cases where case_history like '%ACT%' Finds the word ACT but also contact, actor, contractor, and so on. I do need it to find words like updates if the user types update or printing if the user types printer. Also the above query ...

  1. #1

    Default Complete word queries?

    I am trying to create a query that searches for key words in text fields for
    a web based helpdesk application. Currently I am using the like operator
    but if I do a search on problems with ACT (a contact management app) if will
    find all cases with those letters in the history. Example below:

    Select * from cases where case_history like '%ACT%'

    Finds the word ACT but also contact, actor, contractor, and so on. I do
    need it to find words like updates if the user types update or printing if
    the user types printer. Also the above query only finds words that are
    grouped together, so if the user types ACT printing problem, if will only
    find cases that have that exact phrase instead of just the three keywords.


    Any help would be greatly appriciated
    Dan


    Dan Guest

  2. #2

    Default Re: Complete word queries?

    I think you should have a look at Full-text search. BOL has a lot of content
    about it and there is also a newsgroup about it
    (microsoft.public.sqlserver.fulltext). It is a lot more powerful then LIKE,
    and can do things like looking for 3 keywords at once.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Dan Marth" <net> wrote in message
    news:phx.gbl... 
    for 
    will 


    Jacco Guest

Similar Threads

  1. Getting Word Count from MS Word files
    By CNaser in forum Macromedia ColdFusion
    Replies: 0
    Last Post: June 22nd, 03:21 PM
  2. Queries Of Queries Single Quote Problem
    By TimH2O in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 1st, 07:46 PM
  3. Word 2003 to PDF 6.0.1 - crashes at 84% complete
    By Bill_Reckwerdt@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 15th, 12:31 AM
  4. Preventing MS Word Footers being used in word to pdf conversion
    By Doncasters_MIS@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: April 5th, 03:31 PM
  5. Replies: 5
    Last Post: September 1st, 09:48 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139