USP_DATALIST_DEFAULTCOMMENT

CREATE procedure dbo.USP_DATALIST_DEFAULTCOMMENT 
( @INCLUDEINACTIVE bit = 0)
as
    set nocount on;


    select ID, SEQUENCE,
            --If the last character is a vbcrlf, then get rid of it so we don't get a blank space in the datalist.

           case right(TEXTCOMMENT,2) when CHAR(13) + CHAR(10) then SUBSTRING(TEXTCOMMENT, 1, LEN(TEXTCOMMENT) - 2) else TEXTCOMMENT end as TEXTCOMMENT,
           ISACTIVE
    from dbo.DEFAULTCOMMENT
    WHERE   (
                            (@INCLUDEINACTIVE = 1) 
                            or 
                            (ISACTIVE = 1)
                        )
    ORDER BY SEQUENCE ASC