get first name and last name from full name string in sql

Solutions on MaxInterview for get first name and last name from full name string in sql by the best coders in the world

Search
showing results for - "get first name and last name from full name string in sql"
Michele
25 Aug 2017
1DECLARE @FullName    VARCHAR(50) = 'Mark Zuckerberg'
2
3SELECT SUBSTRING(@FullName, 1, CHARINDEX(' ', @FullName) - 1) AS [First Name],
4       SUBSTRING(@FullName, CHARINDEX(' ', @FullName) + 1, LEN(@FullName)) AS [Last Name]
5
source
similar questions
split first name and last name in sqlsql first characterhow to fetch first 5 characters in sqlhow to get last element sqlsql remove first character from stringsql firstsql print all names that start with a given letterreading from right to left from string find first special characters in sqlget first 3 letters in sqlget last record in sqlquery only first letter stringget first 3 letters name in sqlget first monday of month sqlsql first day of current yearsql get month nameselect first and last row sqlmonthname sqlsql get last idsql hello 2c 5bfirstname 5d 5blastname 5djoin first name and last name sqlhow to select first row of database sqlget current month last date in sql serversql select first rowsql server beginning of monthget first 2 letter in sqlget first 3 letter of department name in sqlget first n letter of department name in sql
queries leading to this page
sql check firstname and lastnamesql query last name or first namehow to get firstname and lastname in sql with spacehow to display firstname and last name as onename in sqlsql select first name last name as full namesql first name middle name last name from stringsql get first name middle name and last name from stringselect first name and last name sqlsql firstname and lastnamesql code to display first name and last name as full namesql search for name with 1st character and lastsql where firstname and lastnamehow to get firstname from firstname and lastname using sqlseparating first and last name in sqlsql select firstname and lastnameselect firstname and lastname as name sqlsql statement to display first and last namesql view for first name 2b middle name 2b last name as name examplesql first and last name to full namesql query last name smit or first name miket sql where lastname or first name or bothselect full name out of first name and last name in sqlsql select first letter first name followed by space and last nameget first name and last name from full name string in sql