How do I split a delimited string so I can access individual items?

by

I don’t believe SQL Server has a built-in split function, so other than a UDF, the only other answer I know is to hijack the PARSENAME function:

SELECT PARSENAME(REPLACE('Hello John Smith', ' ', '.'), 2)

PARSENAME takes a string and splits it on the period character. It takes a number as its second argument, and that number specifies which segment of the string to return (working from back to front).

SELECT PARSENAME(REPLACE('Hello John Smith', ' ', '.'), 3)  --return Hello

Obvious problem is when the string already contains a period. I still think using a UDF is the best way…any other suggestions?

More Related Contents:

  1. How do I split a string so I can access item x?
  2. T-SQL split string
  3. Split one column value into multiple column values
  4. How to create a specific SQL Server stored procedure? [closed]
  5. SQL Server dynamic PIVOT query?
  6. SQL Server – Best way to get identity of inserted row?
  7. Should I use != or for not equal in T-SQL?
  8. How to update two tables in one statement in SQL Server 2005?
  9. SQL Server Process Queue Race Condition
  10. How should I pass a table name into a stored proc?
  11. Is the NOLOCK (Sql Server hint) bad practice?
  12. SQL – Subtracting a depleting value from rows
  13. SQL query to split column data into rows
  14. How to drop SQL default constraint without knowing its name?
  15. Equivalent of Oracle’s RowID in SQL Server
  16. Sequence vs identity
  17. Dynamic update statement with variable column names
  18. How to select only the first rows for each unique value of a column?
  19. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  20. SQL “between” not inclusive
  21. Unordered results in SQL
  22. Using PIVOT in SQL Server 2008
  23. How to find column names for all tables in all databases in SQL Server
  24. SQL Row_Number() function in Where Clause
  25. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  26. How do I compare 2 rows from the same table (SQL Server)?
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment