How do i split strings in SQL server? [duplicate]

by 
CREATE FUNCTION [dbo].[fnSplitString] 
( 
    @string NVARCHAR(MAX), 
    @delimiter CHAR(1) 
) 
RETURNS @output TABLE(splitdata NVARCHAR(MAX) 
) 
BEGIN 
    DECLARE @start INT, @end INT 
    SELECT @start = 1, @end = CHARINDEX(@delimiter, @string) 
    WHILE @start < LEN(@string) + 1 BEGIN 
        IF @end = 0  
            SET @end = LEN(@string) + 1

        INSERT INTO @output (splitdata)  
        VALUES(SUBSTRING(@string, @start, @end - @start)) 
        SET @start = @end + 1 
        SET @end = CHARINDEX(@delimiter, @string, @start)

    END 
    RETURN 
END

This will Split the string into Words, from there you have to be more specific on what substring you want from the initial string.

This is for SQL Server.

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  3. How can I escape square brackets in a LIKE clause?
  4. Parameter Sniffing (or Spoofing) in SQL Server
  5. How can I truncate a datetime in SQL Server?
  6. What are the main performance differences between varchar and nvarchar SQL Server data types?
  7. SQL Server String or binary data would be truncated
  8. Datatype for storing ip address in SQL Server
  9. SQL Server: Query fast, but slow from procedure
  10. SQL Server Regular expressions in T-SQL
  11. Is there a way to loop through a table variable in TSQL without using a cursor?
  12. Concatenating Column Values into a Comma-Separated List
  13. What columns generally make good indexes?
  14. List the queries running on SQL Server
  15. SQL Server pivot vs. multiple join
  16. SQL Server Bulk insert of CSV file with inconsistent quotes
  17. What is a free tool to compare two SQL Server Databases? [closed]
  18. SQL Server Query: Fast with Literal but Slow with Variable
  19. How can I make HTTP request from SQL server?
  20. SQL Server Management Studio alternatives to browse/edit tables and run queries [closed]
  21. Format SQL in SQL Server Management Studio
  22. SQL Server, the misleading XLOCK & optimizations
  23. #DELETE viewing SQL Server table in Access
  24. Grant Select on a view not base table when base table is in a different database
  25. SQL Server (localdb)\v11.0 explained
  26. migrate data from MS SQL to PostgreSQL?
  27. SQL Server – join rows into comma separated list
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment