This doesn't take into consideration that the code string in syscomments i split after each 4000 characters set.
You need to do a left join on colid + 1 and do the like match on the whole concatenated rows.
Of course, we don't have that problem in 2k5 with the new system views.