How to split a single column values to multiple column values?

by

Your approach won’t deal with lot of names correctly but…

SELECT CASE
         WHEN name LIKE '% %' THEN LEFT(name, Charindex(' ', name) - 1)
         ELSE name
       END,
       CASE
         WHEN name LIKE '% %' THEN RIGHT(name, Charindex(' ', Reverse(name)) - 1)
       END
FROM   YourTable

More Related Contents:

  1. Better techniques for trimming leading zeros in SQL Server?
  2. How do I remove extended ASCII characters from a string in T-SQL?
  3. Is it possible to write single query on two table which are not connected to each other?
  4. How to create a specific SQL Server stored procedure? [closed]
  5. Should I use != or for not equal in T-SQL?
  6. How to update two tables in one statement in SQL Server 2005?
  7. Create a date from day month and year with T-SQL
  8. How should I pass a table name into a stored proc?
  9. SQL: IF clause within WHERE clause
  10. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  11. SQL Server – How to lock a table until a stored procedure finishes
  12. Where value in column containing comma delimited values
  13. What is the difference between using a cross join and putting a comma between the two tables?
  14. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  15. Pivot using SQL Server 2000
  16. How to count instances of character in SQL Column
  17. Sequence vs identity
  18. How to update and order by using ms sql
  19. How to store image in SQL Server database tables column [duplicate]
  20. SQL “between” not inclusive
  21. Can I set ignore_dup_key on for a primary key?
  22. SQL Server replace, remove all after certain character
  23. How to find column names for all tables in all databases in SQL Server
  24. Inserting rows into a table with one IDENTITY column only [duplicate]
  25. SQL Row_Number() function in Where Clause
  26. When using GETDATE() in many places, is it better to use a variable?
  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