How to get the 1st value before delimiter in sql server

by

You can use SUBSTRING to do this:

SELECT 
    SUBSTRING(TRN02, 0, CHARINDEX('-', TRN02)) AS [First]
    SUBSTRING(TRN02, CHARINDEX('-', TRN02)  + 1, LEN(TRN02)) AS [Second]
FROM TABLE

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. SQL Server insert if not exists best practice [closed]
  3. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  4. Are GUID collisions possible?
  5. Does a foreign key automatically create an index?
  6. best way to convert and validate a date string
  7. Why do table names in SQL Server start with “dbo”?
  8. Add alternating row color to SQL Server Reporting services report
  9. LIKE vs CONTAINS on SQL Server
  10. How do I enable MSDTC on SQL Server?
  11. How Do I Split a Delimited String in SQL Server Without Creating a Function?
  12. What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
  13. Is there any difference between DECIMAL and NUMERIC in SQL Server?
  14. How to enable bulk permission in SQL Server
  15. SQL Server history table – populate through SP or Trigger?
  16. Should every User Table have a Clustered Index?
  17. How to load an XML file into a database using an SSIS package?
  18. TSQL: Create a view that accesses multiple databases
  19. How to connect to MS SQL Server using Inno Setup?
  20. Check if a temporary table exists and delete if it exists before creating a temporary table
  21. SQL count rows in a table
  22. What is the sql connection string I need to use to access localhost\SQLEXPRESS with Windows Authentication or SQL Authentication?
  23. SQL Error with Order By in Subquery
  24. Executing set of SQL queries using batch file?
  25. How to change default language for SQL Server?
  26. Grant Select on a view not base table when base table is in a different database
  27. Database design: Calculating the Account Balance
  28. migrate data from MS SQL to PostgreSQL?
  29. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  30. Oracle sequence but then in MS SQL Server

Leave a Comment