泛微：显示所有流程名SQL

  select case when charindex('~`~`7',typename)>0 then substring(typename,7,charindex('`~`8 ',typename)-7) else typename end,
         case when charindex('~`~`7',workflowname)>0 then substring(workflowname,7,charindex('`~`8 ', workflowname)-7) 
         else workflowname end
  from workflow_type wft --流程对应的大目录信息
       left join workflow_base wfb on wfb.workflowtype=wft.id
   where workflowname not like '%停用%'
         and workflowname not like '%V%'