Python_No1的博客

mssql查询括号前的数据及括号中的数据select CASE WHEN CHARINDEX('—',Name)=0 THEN REVERSE(stuff(reverse(Name), 1, charindex('(', reverse(Name)), '')) ELSE '' END AS name,CASE WHEN CHARINDEX('（',Name)>0 THEN SUBSTRING(Name , charindex('（' , Name) + 1 , charindex('）' ,