create procedure RReplace
  @inSrcStr          varchar( 255 )       ,           
  @inSearchStr      varchar( 255 )       ,           
  @inReplStr     varchar( 255 )       ,           
  @OutStr varchar( 255 ) OUTPUT

as

begin
  declare
    @ReplacePos           INT      ,                
    @TmpStr            varchar( 255 ),                
    @TmpSearchStr      varchar( 255 ),                
    @TmpReplaceStr     varchar( 255 ),                
    @TmpOutStr varchar( 255 )                 


  select @TmpStr  = @inSrcStr
  select @TmpSearchStr  = @inSearchStr
  select @TmpReplaceStr = @inReplStr
  select @ReplacePos = patindex('%'+@TmpSearchStr+'%', @inSrcStr)

  if (@ReplacePos >  0  )
  begin
    select @TmpOutStr = ''
    while @ReplacePos >  0                        
    begin                                          
      select @TmpOutStr = @TmpOutStr + substring(@TmpStr,  1 , @ReplacePos- 1 ) + @locReplaceStr
      select @TmpStr = substring(@TmpStr, @ReplacePos+char_length(@TmpSearchStr), char_length(@TmpStr))
      select @ReplacePos = patindex('%'+@TmpSearchStr+'%', @TmpStr)
    end
    select @OutStr = @TmpOutStr + @TmpStr 
  end
  else
    select @OutStr = @TmpStr 
end