Get everything after and before certain character in SQL Server

by

use the following function

left(@test, charindex("https://stackoverflow.com/", @test) - 1)

More Related Contents:

  1. SQL Server dynamic PIVOT query?
  2. SQL Server – Best way to get identity of inserted row?
  3. SQL Server Process Queue Race Condition
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. SQL Server 2005 Pivot on Unknown Number of Columns
  6. Creating table names that are reserved words/keywords in MS SQL Server [closed]
  7. SQL – Subtracting a depleting value from rows
  8. Stored procedure or function expects parameter which is not supplied
  9. Pass table as parameter into sql server UDF
  10. SQL Server Convert Varchar to Datetime
  11. There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key
  12. OPTION (RECOMPILE) is Always Faster; Why?
  13. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  14. SQL – Query to get server’s IP address
  15. Remove numbers from string sql server
  16. What is the equivalent of ‘describe table’ in SQL Server?
  17. Difference of two date time in sql server
  18. Modify Default value in SQL Server
  19. Unordered results in SQL
  20. Using PIVOT in SQL Server 2008
  21. Produce DISTINCT values in STRING_AGG
  22. Function in SQL Server 2008 similar to GREATEST in mysql?
  23. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  24. Query times out from web app but runs fine from management studio
  25. How do I compare 2 rows from the same table (SQL Server)?
  26. Should I use the CASCADE DELETE rule? [duplicate]
  27. Dynamic order direction
  28. Why is RAND() not producing random numbers?
  29. SQL, How to Concatenate results?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment