Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. codecontractor

    Copying rows between tables

    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...
  2. codecontractor

    Plurals and Inflectional Full Text Searching

    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...
  3. codecontractor

    Updating a Live Table using a New Table

    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...
  4. codecontractor

    Full-Text Search misses last word?

    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...
  5. codecontractor

    Full-text Search with ADP to SQL Server

    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...
  6. codecontractor

    Pattern Matching "OR"

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

Part and Inventory Search

Back
Top