The [text] column in syscomments is nvarchar(4000). If the length of the text for the object is greater that 4000, it will be split into two or more rows. Be advised that when searching syscomments with LIKE, there is a slight possibility that the string you are searching for could be split and cross over into the next row. In that case, LIKE will not find a match. Granted, it's a relatively remote possibility, but it could happen.