求助，将一个oracle的自定义函数转换成sql server的

[瘦马]

如题，将一个oracle的自定义函数转换成sql server的

create or replace function JM_decryption(name in varchar2) return varchar2 is
  Result varchar2(400);
  ls_sql varchar2(4000);
  v_length number := (length(name) - 2) / 9;
  v_mm  varchar2(4000);
  m number;
begin
   begin
for i in 1 .. v_length loop
      m:= i * 7 - 6;
      ls_sql := 'select a.key from jm a where a.pass =substr(regexp_replace(''' || name || ''', ''\^1V6|V6'', ''''), ' || m || ', 7)';
      execute immediate ls_sql  into v_mm;
      Result := Result || v_mm;
end loop;
exception when others then Result := '';
end;
return(Result);
end;

[LongRui888]

sql server没有内置的正则表达式的函数，处理不了正则表达式。。。

[瘦马]

顶上去再次求助