A SQL Query to select a string between two known strings

by

The problem is that the second part of your substring argument is including the first index.
You need to subtract the first index from your second index to make this work.

SELECT SUBSTRING(@Text, CHARINDEX('the dog', @Text)
, CHARINDEX('immediately',@text) - CHARINDEX('the dog', @Text) + Len('immediately'))

More Related Contents:

  1. Get the character between first 2 special character in SQL
  2. What is wrong with this DB Diagram? [closed]
  3. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  4. SQL Server Subquery a
  5. Efficiently convert rows to columns in sql server
  6. Not equal != operator on NULL
  7. SET NOCOUNT ON usage
  8. How can I get column names from a table in SQL Server?
  9. How can I select the first day of a month in SQL?
  10. Copy tables from one database to another in SQL Server
  11. error, string or binary data would be truncated when trying to insert
  12. Is it possible to specify condition in Count()?
  13. How to Replace Multiple Characters in SQL?
  14. EXISTS vs JOIN and use of EXISTS clause
  15. SQL count(*) performance
  16. Why is a UDF so much slower than a subquery?
  17. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  18. SQL comma-separated row with Group By clause
  19. How to split string using delimiter char using T-SQL?
  20. Get everything after and before certain character in SQL Server
  21. T-SQL trim &nbsp (and other non-alphanumeric characters)
  22. UNIX_TIMESTAMP in SQL Server
  23. I want to use CASE statement to update some records in sql server 2005
  24. Sql Server trigger insert values from new row into another table
  25. How to return a incremental group number per group in SQL
  26. Retrieve column names and types of a stored procedure? [duplicate]
  27. UNION ALL vs OR condition in sql server query
  28. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  29. Add a row number to result set of a SQL query
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment