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

by

Try this:

UPDATE YourTable
SET Col2 = RIGHT(Col1,LEN(Col1)-CHARINDEX("https://stackoverflow.com/",Col1))

More Related Contents:

  1. Turning a Comma Separated string into individual rows
  2. Update a table using JOIN in SQL Server?
  3. Using T-SQL, return nth delimited element from a string
  4. SQL Update with row_number()
  5. How do I split a string so I can access item x?
  6. How can I remove duplicate rows?
  7. How to split a comma-separated value to columns
  8. SQL Server: Examples of PIVOTing String data
  9. What is the use of GO in SQL Server Management Studio & Transact SQL?
  10. SELECT DISTINCT on one column
  11. Confused about UPDLOCK, HOLDLOCK
  12. Retrieve column definition for stored procedure result set
  13. SQL Server split CSV into multiple rows
  14. Using varchar(MAX) vs TEXT on SQL Server
  15. Change Notification with Sql Server 2008
  16. How do you create a yes/no boolean field in SQL server?
  17. Connecting to MS SQL Server with Windows Authentication using Python?
  18. Using COALESCE function to make values separated with commas
  19. TSQL Email Validation (without regex)
  20. How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
  21. How to find the port for MS SQL Server 2008?
  22. Assign result of dynamic sql to variable
  23. How do I create a multiple-table check constraint?
  24. Drop primary key using script in SQL Server database [duplicate]
  25. OR Operator Short-circuit in SQL Server
  26. Removing the remembered login and password list in SQL Server Management Studio
  27. T-SQL XOR Operator
  28. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  29. Convert from DateTime to INT
  30. Is it possible to use user defined aggregates (clr) with window functions (over)?

Leave a Comment