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.