Is there a LastIndexOf in SQL Server?

by

If you want everything after the last _, then use:

select right(db_name(), charindex('_', reverse(db_name()) + '_') - 1)

If you want everything before, then use left():

select left(db_name(), len(db_name()) - charindex('_', reverse(db_name()) + '_'))

More Related Contents:

  1. Get the mentioned output by SQL query
  2. I need help formatting inner join command in SQL query
  3. Calculate a Running Total in SQL Server
  4. LIMIT 10..20 in SQL Server
  5. SQL transpose full table
  6. How to Create a real one-to-one relationship in SQL Server
  7. Difference between “read commited” and “repeatable read”
  8. Reference alias (calculated in SELECT) in WHERE clause
  9. Implement paging (skip / take) functionality with this query
  10. Copy data into another table
  11. When to use Common Table Expression (CTE)
  12. How to replace a string in a SQL Server Table Column
  13. How to send email from SQL Server?
  14. SQL server ignore case in a where expression
  15. How To Create Table with Identity Column
  16. Find closest date in SQL Server
  17. SQL Server LIKE containing bracket characters
  18. Can we pass parameters to a view in SQL?
  19. Alternate of lead lag function in SQL Server 2008
  20. “Order By” using a parameter for the column name
  21. DISTINCT for only one column
  22. How do I create and query linked database servers in SQL Server?
  23. Add emoji / emoticon to SQL Server table
  24. How to search SQL column containing JSON array
  25. Perform regex (replace) in an SQL query
  26. What is the internal representation of datetime in sql server?
  27. Eliminate and reduce overlapping date ranges
  28. SELECT max(x) is returning null; how can I make it return 0?
  29. SQL INSERT INTO from multiple tables
  30. How to Execute SQL Query without Displaying results

Leave a Comment