SQL Server:任何等价于 strpos() 的东西? [英] SQL Server: any equivalent of 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() 的东西?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！