sql 替换语句

replace("字段","内容","替换内容");

例如：

ALTER PROCEDURE [dbo].[UP_GetDateRanking]

@Top int=0,
@daytime datetime --查询日期
AS
BEGIN
 DECLARE @st varchar(20);
    DECLARE @et varchar(20);
    SET @st=(Select CONVERT(varchar(100), @daytime, 23)+' 00:00:00');
    SET @et=(Select CONVERT(varchar(100), @daytime, 23)+' 23:59:59');
 DECLARE @topNum varchar(10)
      SET @topNum=''
 IF @Top>0
     SET @topNum=' Top '+ltrim(@Top)

 DECLARE @sql varchar(5000)
     SET @sql='SELECT @topNum ofId,REPLACE(ofLogin,substring(ofLogin,4,4),''****'') as 商户,(SELECT SUM(ofAmount) FROM IP_OfficeFinance WHERE IP_OfficeFinance.ofId=IP_OfficeInfo.ofId AND ofType=2 and ofTime between '''+@st+''' and '''+@et+''') AS 总销售额,''暂未开放'' as 奖励积分 FROM  IP_OfficeInfo ORDER BY 总销售额 desc'
   set @sql=replace(@sql,'@topNum',@topNum)
   print @sql
 exec(@sql)
END