Declare
 @bst varchar(1000),
 @pst varchar(1000),
 @ost varchar(1000),

 @t_cnt int = 1;

WHILE @t_cnt <= (SELECT count(*) FROM t_temp)

BEGIN


 SELECT @bst = g_Search_Text FROM t_temp WHERE id = @t_cnt;
 SELECT @pst = p_Search_Text FROM t_temp WHERE id = @t_cnt;
 SELECT @ost = o_Search_Text FROM t_temp WHERE id = @t_cnt;

       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;
 SET @t_cnt = @t_cnt + 1
END;