December 01, 2002 07:01 PM
Do-It-Yourself Searching
Save money and effort by creating a custom search solution
Rating:

(0)
SQL Server Magazine
InstantDoc ID #27195
Periodically, you need to search a database for specific words or phrases in strings. Users of a music Web site might need to search for CD titles; a bookselling site might offer searches by title or author. Queries that use the LIKE keyword are notoriously slow for this type of search because typical database indexes can't help in searching for words that appear in the middle of a string such indexes help only in searching from the beginning of a string. To address the need for better te...
You must be a paid Professional Member to access this entire article.
Already a Professional Member? Please log in now: