Use PATINDEX to search for two consecutive line terminators.  So the next question is whether your data uses Windows (CrLf), Mac(Cr), or Unix(Lf) line terminators.

Of course, this assume that the "blank" lines are truly blank rather containing non-printing characters like spaces and tabs.

Drew