• Hi Team,

    BEGIN

    SELECT RTRIM(

    +ISNULL(Col_Name,'')+' : '

    +ISNULL(+CAST(ColB AS VARCHAR(10))+' ','')

    +ISNULL(' ColC :'+CAST(ColC AS VARCHAR(10))+' ','')

    ) FROM table_name

    END

    --

    if ColB is NULL then ColC should not append .

    Please help....