the preferred way is to use full-text search, see
Full Text Searching with SQL Server 2000
http://tutorials.findtutorials.com/read/id/416but trySELECT id, title
FROM articles
WHERE id in
(SELECT CASE WHEN r_id = 0 THEN id ELSE r_id END
FROM articles WHERE content LIKE '%MYKEYWORD%')
Full Text Searching with SQL Server 2000
http://tutorials.findtutorials.com/read/id/416but trySELECT id, title
FROM articles
WHERE id in
(SELECT CASE WHEN r_id = 0 THEN id ELSE r_id END
FROM articles WHERE content LIKE '%MYKEYWORD%')
I cannot using full-text search for some reason, but your advice is very good anyway.
Thank you very much!