alexanderthegreat
IS-IT--Management
Select * from activities where activityname contains 'holiday'
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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Whats wrong with this select statement? In fact Whats wrong with Me? ;
- Thread starter alexanderthegreat
- Start date
- Status
You can use CONTAINS, but there is specific criteria for its use. The number 1 criteria is that the column must have been registered for full-text searching (Per the BOL).
Next, the proper format is:
WHERE CONTAINS (column_name, 'search condition')
As for "In fact, what's wrong with me?"...sorry you don't give enough information for us to solve that issue.![[lol]](/data/assets/smilies/lol.gif "[lol] [lol]")
-SQLBill
Posting advice: FAQ481-4875
Next, the proper format is:
WHERE CONTAINS (column_name, 'search condition')
As for "In fact, what's wrong with me?"...sorry you don't give enough information for us to solve that issue.
-SQLBill
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question