Search results for query: *

PS. The Remote table is linked in, by the way.

I've got two tables with the exact same design. One is remote and one is local and I am trying to mirror the local one with the remote one. So, I'm checking for new rows and removed rows, but I'm having trouble inserting a whole row when I find one that needs to be added. I tried creating the...

Thanks for your help guys. For the time being I'm using the Chuggnut implementation of the Porter Stemming Algorithm to find the stem and then I use Match ( "stem*" ). This isn't a perfect solution as "windy" would also find "windlass", but it'll do for now. Thanks again, -Ben

I've searched all over and havn't found anyone who's documented any good word variation search for MySQL. I undertand that searching for inflectional versions of words can be quite tricky, but MSSQL does it... Does anyone know of a PHP tool or something to adjust the query string before...

Wow, thanks. That works perfectly. This is how I have changed it: ALTER PROCEDURE UpdateLive -- This code finds records where the Title -- field has changed in NEW and adjusts LIVE AS UPDATE live SET live.Title = new.Title, live.Field2 = New.Field2, Live.Field3 = New.Field3...

Ok, first of all, I would like to thank you all for your guidance in the past. I am new to SQL and SQL Server, but with the help of this forum I have picked it up pretty quickly. So, my situation is: I have a live (actively used) table which is full text indexed. I have another table that is...

Herreshoff shows up and I tried Yachts as well and that worked.

Sorry, here it is: ALTER PROCEDURE CRSearchProc ( -- Search Term @word varChar(64) ) AS DECLARE @query varChar(128) SET @query = 'FORMSOF (INFLECTIONAL, ' + @word + ')' SELECT * FROM TABLE WHERE CONTAINS ( Description, @query )

Does full text indexing not include the last word in a phrase? I have found that the last word in a field of several sentances is universally missed in my 'contains inflectional forms of...' queries. Is this a known bug, or am I doing something wrong either in my query or my indexing? Here are...

I have a database on a hosted SQL Server. I modify the tables on my local machine in a regular MDB file and upload new versions regularly through an ADP connected to the server. They recently set up full-text search for several tables. Before they set up the full text indexing I would simply...

Ok, I've brought it down to its simplest form, I think. It appears that the wildcards are not getting evaluated. Here is an example. SELECT * FROM table WHERE Title IN ( '%' + @searchString + '%' -- line in question ) I have tested that by manually by putting '%a%' in for the...

Thank you! That almost works. However, I should have mentioned in my first post that I have to use regular expressions because these aren't exact matches. I have tested a few regular expressions within the context of IN, but it doesn't seem to be evaluating them... This is what I tried to do...

I'm looking for a way to streamline the following stored procedure query using regular expressions: --------------------------------------- SELECT * FROM TitleTable WHERE Title like @searchString OR Title like @searchString + 's' OR Title like @searchString + 'es' OR Title like @searchString +...