sql server 获取字符串 反向获取

declare @woidpre varchar(50);
declare @DMRNoExterior varchar(50);

set @woidpre='DMR'+@WOID;
select top 1 @DMRNoExterior=DMRNoExterior from dbo.F_DMRExterior where WOID=@WOID  order by cast(reverse(left(reverse(DMRNoExterior),charindex('-',reverse(DMRNoExterior))-1)) as int) desc;
if(@DMRNoExterior is null)
begin
 select @woidpre+'-F-1';
end
else
begin
 select @woidpre+'-F-'+cast((cast(reverse(left(reverse(@DMRNoExterior),charindex('-',reverse(@DMRNoExterior))-1)) as int)+1) as varchar(10));
end