SQL Server – find nth occurrence in a string

by

You can use the same function inside for the position +1

charindex('_', [TEXT], (charindex('_', [TEXT], 1))+1)

in where +1 is the nth time you will want to find.

More Related Contents:

  1. Subquery in select not working in SQL Server
  2. Storing images in SQL Server?
  3. How to create jobs in SQL Server Express edition
  4. Confused about UPDLOCK, HOLDLOCK
  5. Retrieve column definition for stored procedure result set
  6. Using varchar(MAX) vs TEXT on SQL Server
  7. SQL Server – Remove all non-printable ASCII characters
  8. Creating audit triggers in SQL Server
  9. Regular Expressions in SQL Server servers?
  10. Unique constraint on multiple columns
  11. Connecting to MS SQL Server with Windows Authentication using Python?
  12. TSQL Email Validation (without regex)
  13. Dynamic SQL results into temp table in SQL Stored procedure
  14. Diagnosing Deadlocks in SQL Server 2005
  15. How to find the port for MS SQL Server 2008?
  16. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  17. TABLOCK vs TABLOCKX
  18. How to convert number of minutes to hh:mm format in TSQL?
  19. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  20. Dynamically assign filename to excel connection string
  21. Temporarily disable all foreign key constraints
  22. SQL Server Dependencies
  23. SQL Server Passthrough query as basis for a DAO recordset in Access
  24. T-SQL query to show table definition?
  25. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. How to convert text column to datetime in SQL
  29. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment