怎么替换没有结果?
declare @str nvarchar(20)select @str = (select replace(re_file,char(13),' ') from bargain_h where flow_id = 1346)update bargain_h set re_file = @str where flow_id = 1346
declare @str nvarchar(20)select @str = (select replace(re_file,char(13),' ') from bargain_h where flow_id = 1346)update bargain_h set re_file = @str where flow_id = 1346
declare @str int
select @str=(charindex(char(13),re_file)) from bargain_h where flow_id=1346
select @str
如果返回为0,表示没有回车