Skip to content
Advertisement

Update column by removing text in braces

I need to update single column for all the rows in a table. The update should happen in such way that data needs be filtered out by removing all text where braces are appended for the string and swap the strings separated by ','.

Example:

As per the above example, I need the final data to be something like this

Please let me know how we can achieve the above output in SQL Server.

Advertisement

Answer

Try this SQL Code:

Output

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement