DECLARE @CHAINE AS VARCHAR(500)
DECLARE @MONMOT AS VARCHAR(50)
SET @CHAINE = 'Mettre en gras MonMot dans ma phrase, recherchons MonMot'
SET @MONMOT = 'MonMot'
SELECT
@CHAINE AS MaChaine,
@MONMOT AS MonMot,
REPLACE(@CHAINE, @MONMOT, '<B>'+ @MONMOT +'</B>') AS MotRemplace