Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Conjurer
Starting Member
30 Posts |
 Posted - 2005-11-04 : 17:23:07
|
| I tried the following select:select * from patientprofile where contains (BillingNotes, '572576-02')And got the errormessage:Server: Msg 7601, Level 16, State 2, Line 1Cannot use a CONTAINS or FREETEXT predicate on table 'patientprofile' because it is not full-text indexed.It shows BillingNotes as a text column Is there a differnet way I can search this note field for records that contain that text value (572576-02) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-04 : 17:35:10
|
| select * from patientprofile where BillingNotes LIKE '%572576-02%'Tara Kizer |
 |
|
|
Conjurer
Starting Member
30 Posts |
Posted - 2005-11-04 : 17:49:17
|
| Wowza, that is it!Thanks so much....now I can move to part 2 question in a new post. :-) |
|
|
|
collinc
Starting Member
1 Post |
Posted - 2010-03-25 : 10:12:03
|
| This helped me a lot too, thanks. :)Collin ChandlerClear Idea Technology, Inc.Sarasota, FL |
|
|
|
|
|
|
Cannot use a Contains on Freetext