ASCII Characters In Stored Procedrues

I have a problem with alot of my SPs. All compile correctly but cause erroneous data due to IF statements begin ignored due to


characters (see below).


Example SP...
-- Opened within last 12 Months

IF @NEWACCIND = 1
BEGIN

EXECUTE usp_DFDX03_D0150_A4 @COSTALL OUTPUT
END

-- Accounts in Arrears in Current Quarter

Should look like ...

-- Opened within last 12 Months
IF @NEWACCIND = 1
BEGIN

EXECUTE usp_DFDX03_D0150_A4 @COSTALL OUTPUT
END
-- Accounts in Arrears in Current Quarter

I need to find all SPs with double

instance and manually replace. There are hundreds of SPs in total. I have tried

SELECTCOLID, ID
FROMSYSCOMMENTS
WHERECHARINDEX (CONVERT (VARCHAR(3), CHAR(13)+CHAR(13)), TEXT) > 0

but this also returns SPs containing 2 consecutive blank lines as well (which there are alot of due to formatting of T-SQL).
Really I need to distuinguish between
and new line which both appear to be CHAR(13)

Any one got any ideas

Thanks in advance

Jasper