T-SQL substring – separating first and last name

by

Assuming the FirstName is all of the characters up to the first space:

SELECT
  SUBSTRING(username, 1, CHARINDEX(' ', username) - 1) AS FirstName,
  SUBSTRING(username, CHARINDEX(' ', username) + 1, LEN(username)) AS LastName
FROM
  whereever

More Related Contents:

  1. T-SQL: Export to new Excel file
  2. SQL MERGE statement to update data
  3. How to get the last record per group in SQL
  4. How to get week number of the month from the date in sql server 2008
  5. T-SQL strip all non-alpha and non-numeric characters
  6. Avoiding IF ELSE due to variable been NULL
  7. Recursive Child/Parent queries in T/SQL
  8. to select all the employees who have joined most recently under king
  9. Unpivot with column name
  10. Get first day of week in SQL Server
  11. How to connect to local instance of SQL Server 2008 Express
  12. Convert varchar into datetime in SQL Server
  13. Export query result to .csv file in SQL Server 2008
  14. Check if a row exists, otherwise insert
  15. Convert Xml to Table SQL Server
  16. TSQL: How to convert local time to UTC? (SQL Server 2008)
  17. How can I load a large flat file into a database table using SSIS?
  18. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  19. How does this CASE expression reach the ELSE clause?
  20. TransactSQL to run another TransactSQL script
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. Store multiple bit values in a single table column
  23. SQL Server equivalent to MySQL enum data type?
  24. Grant SELECT permission on a view, but not on underlying objects
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. Restoring database from .mdf and .ldf files of SQL Server 2008
  27. Restrict SQL Server Login access to only one database
  28. Average of multiple columns
  29. How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment