如何获取SQL Server中点值之前和之后的字符? [英] How to get the characters before and after a dot value in SQL server ?
本文介绍了如何获取SQL Server中点值之前和之后的字符?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何获取sql server中点值前后的字符?
例如:如果我的字符串是[NTP-228]。我想要测试得到[NTP-228]&作为单独的值测试。
我尝试过:
< pre lang =sql> SET @ extension = SUBSTRING( @originalstring ,CHARINDEX(' 。', @ originalstring-1 ), 999 )
SELECT @ extension
但是没有工作。我希望在之前和之后得到字符串。
解决方案
请运行此查询:
声明 @ extension varchar ( 100 ),
@ Code varchar ( 500 ),
@ originalstring varchar ( 100 )= ' [NTP-228] .Test'
SET @ extension = SUBSTRING ( @ originalstring ,CHARINDEX(' 。', @ originalstring )+ 1, 99 9 )
set @Code = SUBSTRING( @ originalstring , 0 ,CHARINDEX(' 。', @ originalstring ))
选择 @ extension , @ Code
Ashish
How to get the characters before and after a dot value in sql server ?
For Eg : If my string is [NTP-228].Test i want to get [NTP-228] & Test as separate values.
What I have tried:
SET @extension = SUBSTRING(@originalstring, CHARINDEX('.', @originalstring-1), 999)
SELECT @extension
bUT NOT WORKING. I want to get the string before and after.
解决方案
Please run this query:
declare @extension varchar(100), @Code varchar(500), @originalstring varchar(100)='[NTP-228].Test' SET @extension = SUBSTRING(@originalstring, CHARINDEX('.', @originalstring)+1, 999) set @Code=SUBSTRING(@originalstring,0, CHARINDEX('.', @originalstring)) select @extension,@Code
Ashish
这篇关于如何获取SQL Server中点值之前和之后的字符?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文