Contains - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Contains

Author

Topic

godspeedba
Yak Posting Veteran

90 Posts

Posted - 2009-05-04 : 07:51:26

Hello friends.

I have the below stored procedure that I want to add a check to not get the record if http is displayed in the message. I have tried where not contains("http") but this didnt work

SELECT
Top 5
[id],
[name],
[message]
FROM
tbl_messageboard
ORDER BY
id

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-04 : 07:55:04

CONTAINS need FULLTEXT to be installed.

SELECT
Top 5
[id],
[name],
[message]
FROM tbl_messageboard
where message not like 'http://%'
ORDER BY id

E 12°55'05.63"
N 56°04'39.26"