本文介绍了SQL Server:任何等价于 strpos() 的东西?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在处理一个烦人的数据库,其中一个字段包含真正应该存储的两个单独字段的内容.因此该列存储的内容类似于第一个字符串~@~第二个字符串",其中~@~"是分隔符.(再说一次,这不是我设计的,我只是想修复它.)
I'm dealing with an annoying database where one field contains what really should be stored two separate fields. So the column is stored something like "The first string~@~The second string", where "~@~" is the delimiter. (Again, I didn't design this, I'm just trying to fix it.)
我想要一个查询将它移到两列中,看起来像这样:
I want a query to move this into two columns, that would look something like this:
UPDATE UserAttributes
SET str1 = SUBSTRING(Data, 1, STRPOS(Data, '~@~')),
str2 = SUBSTRING(Data, STRPOS(Data, '~@~')+3, LEN(Data)-(STRPOS(Data, '~@~')+3))
但我找不到任何与 strpos 等效的存在.
But I can't find that any equivalent to strpos exists.
推荐答案
用户字符索引:
Select CHARINDEX ('S','MICROSOFT SQL SERVER 2000')
Result: 6
这篇关于SQL Server:任何等价于 strpos() 的东西?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!