Split string and take last element

by

The way to do it in SQL : 

SELECT SUBSTRING( string , LEN(string) -  CHARINDEX("https://stackoverflow.com/",REVERSE(string)) + 2  , LEN(string)  ) FROM SAMPLE;

JSFiddle here http://sqlfiddle.com/#!3/41ead/11

More Related Contents:

  1. How do I split a string so I can access item x?
  2. T-SQL split string
  3. How do I split a delimited string so I can access individual items?
  4. Split one column value into multiple column values
  5. The multi-part identifier could not be bound
  6. Subquery using Exists 1 or Exists *
  7. How can I query a value in SQL Server XML column
  8. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  9. SQL – How to store and navigate hierarchies?
  10. SQL Server indexes – ascending or descending, what difference does it make?
  11. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  12. Update records in table from CTE
  13. Write a number with two decimal places SQL Server
  14. how can I Update top 100 records in sql server
  15. How to insert multiple records and get the identity value?
  16. How can a LEFT OUTER JOIN return more records than exist in the left table?
  17. Count Number of Consecutive Occurrence of values in Table
  18. Group DateTime into 5,15,30 and 60 minute intervals
  19. How to replace (null) values with 0 output in PIVOT
  20. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  21. How can I compare time in SQL Server?
  22. Column name or number of supplied values does not match table definition
  23. Get the records of last month in SQL server
  24. Merge overlapping date intervals
  25. Script to save varbinary data to disk
  26. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  27. alternatives to REPLACE on a text or ntext datatype
  28. SQL poor stored procedure execution plan performance – parameter sniffing
  29. How to find out what is locking my tables?
  30. Export table data from one SQL Server to another

Leave a Comment