How to split a string after specific character in SQL Server and update this value to specific column

sql-server split sql-update
SHEKHAR SHETE picture SHEKHAR SHETE · Feb 13, 2012 · Viewed 246k times · Source

I have table with data 1/1 to 1/20 in one column. I want the value 1 to 20 i.e value after '/'(front slash) is updated into other column in same table in SQL Server.

Example:

Column has value 1/1,1/2,1/3...1/20
new Column value 1,2,3,..20

i.e I want to update this new column

Thanks in advance...!

Answer

Lamak picture Lamak · Feb 13, 2012

Try this:

UPDATE YourTable
SET Col2 = RIGHT(Col1,LEN(Col1)-CHARINDEX('/',Col1))

Related questions

How do I split a string so I can access item x?

Using SQL Server, how do I split a string so I can access item x? Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return "John"?

Read More
Turning a Comma Separated string into individual rows

I have a SQL Table like this: | SomeID | OtherID | Data +----------------+-------------+------------------- | abcdef-..... | cdef123-... | 18,20,22 | abcdef-..... | 4554a24-... | 17,19 | 987654-..... | 12324a2-... | 13,19,20 is there a query where I can perform a query like SELECT OtherID, SplitData WHERE SomeID = 'abcdef-.......' …

Read More
T-SQL split string

I have a SQL Server 2008 R2 column containing a string which I need to split by a comma. I have seen many answers on StackOverflow but none of them works in R2. I have made sure I have select permissions …

Read More