我的表中有一个列具有以下值
| loan_no |
| SSS Pensioner Loan (C000000001) |
| SSS SSS Loan (C000000002) |
| SSS Salary Loan (C000000007) |
| SSS PAGIBIG Loan (C000000003) |
如何只选择括号内的值
得到这样的结果:
| loan_no |
| C000000001 |
| C000000002 |
| C000000007 |
| C000000003 |
先感谢您 :)
我正在使用 SQL Server 2008 R2
CHARINDEX 将为您提供帮助参考 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b4cf5c0b-de2e-4c3d-8dbc-19178fe8ced3/tsql-query-to-read-data-between-brackets?forum=transactsql
declare @temp table
(val nvarchar(77))
insert into @temp values ('SSS Pensioner Loan (C000000001)')
insert into @temp values ('SSS SSS Loan (C000000002) ')
insert into @temp values ('SSS Salary Loan (C000000007) ')
insert into @temp values ('SSS PAGIBIG Loan (C000000003) ')
SELECT
SUBSTRING(val,CHARINDEX('(', val) + 1,CHARINDEX(')', val) - CHARINDEX('(', val) - 1) as Val
from @temp
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)