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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text Search

Status
Not open for further replies.
ice78991

ice78991

Programmer
Joined
Nov 20, 2006
Messages
216
I am planning a database table where a column will hold up to 100 words. I want to be able to query all of the rows in this table for matching text. What is the best way to start going about this in sql server 2005. Should I add a full-text catalog and do I need the enterprise edition?
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
Adding Text to and XML Field
Replies
2
Views
437
grnzbra
grnzbra
ahmedsa2018
  • Locked
  • Question Question
How to display part number based on search string by chemical id ?
Replies
3
Views
447
gmmastros
gmmastros
Cpreston
  • Locked
  • Question Question
Update another column if text in another exists
Replies
4
Views
491
Cpreston
Cpreston
bmacbmac
  • Locked
  • Question Question
How to import plain text from Word doc to SQL
Replies
4
Views
723
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question Question
Help searching within this Json file
Replies
0
Views
364
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top