SQL Server: any equivalent of strpos()?

sql, sql-server, strpos, syntax

Solution

User charindex:

Select CHARINDEX ('S','MICROSOFT SQL SERVER 2000')
Result: 6

Link

Problem

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)) ``` But I can't find that any equivalent to strpos exists.

Original source