WHILE CHARINDEX('  ',@bst) > 0
   BEGIN
          SET @bst = replace(@bst,'  ',' ')
   END
   WHILE CHARINDEX('  ',@pst) > 0
   BEGIN
          SET @pst = replace(@pst,'  ',' ')
   END
   WHILE CHARINDEX('  ',@ost) > 0
   BEGIN
          SET @ost = replace(@ost,'  ',' ')
   END

            update t_temp set b_Search_Text=@bst WHERE id = @t_cnt;
           update t_temp set p_Search_Text=@pst WHERE id = @t_cnt;
            update t_temp set o_Search_Text=@ost WHERE id = @t_cnt;