How to extract this specific substring in SQL Server?

by

Combine the SUBSTRING(), LEFT(), and CHARINDEX() functions.

SELECT LEFT(SUBSTRING(YOUR_FIELD,
                      CHARINDEX(';', YOUR_FIELD) + 1, 100),
                      CHARINDEX('[', YOUR_FIELD) - 1)
FROM YOUR_TABLE;

This assumes your field length will never exceed 100, but you can make it smarter to account for that if necessary by employing the LEN() function. I didn’t bother since there’s enough going on in there already, and I don’t have an instance to test against, so I’m just eyeballing my parentheses, etc.

More Related Contents:

  1. About SQL Server IF clause [closed]
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. When should I use a table variable vs temporary table in sql server?
  4. How can I determine installed SQL Server instances and their versions?
  5. Add IIS 7 AppPool Identities as SQL Server Logons
  6. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  7. How do I format a number with commas in T-SQL?
  8. SQL Server: Database stuck in “Restoring” state
  9. Access is denied when attaching a database
  10. Getting an odd error, SQL Server query using `WITH` clause
  11. Split one column into multiple rows
  12. SQL Unique constraint across multiple tables
  13. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  14. How to store directory / hierarchy / tree structure in the database?
  15. Which is quicker COALESCE OR ISNULL?
  16. Merge multiple rows into a single row
  17. Random record from a database table (T-SQL)
  18. What does the SQL # symbol mean and how is it used?
  19. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  20. Trigger to fire only if a condition is met in SQL Server
  21. Restore a SQL Server 2000 backup on SQL Server 2012
  22. Cross Domain SQL Server Logins Using Windows Authentication
  23. Random Weighted Choice in T-SQL
  24. SQL select all if parameter is null else return specific item
  25. time format in SQL Server
  26. Python – pyodbc call stored procedure with parameter name
  27. How to execute SSIS package when a file is arrived at folder
  28. SQL Server stored procedure return code oddity
  29. ODBC Call Failed with stored procedure – Pass through query
  30. Convert float into varchar in SQL Server without scientific notation

Leave a Comment