Replace function in a query

Question

                @"SELECT 
                                            [MN].[PK_ID],
                                            [MN].[FK_NOTEADDED_BY],
                                            [MN].[ADDED_ON],
                                            REPLACE(MN.NOTE_CONTENT, '\n', '<br/>') AS [NOTE_CONTENT], 
                                            [MU].[FIRST_NAME] + '' + [MU].[LAST_NAME] AS [NAME] 
                                      FROM 
                                            [MAGAZINE_NOTES] [MN] 
                                      INNER JOIN  
                                            [MAGAZINE_USERS] [MU]
                                      ON 
                                            [MN].[FK_NOTEADDED_BY] = [MU].[PK_ID] 
                                      WHERE 
                                            [MN].[FK_NOTEADDED_TO] = " + CurrentMagazineId + " ORDER BY [MN].[PK_ID] DESC";