Find the lastName in SQL table

Why did you come to ? blue clinic As she recovered from a wound that would have set many back years, Malalaâ??s voice has become stronger and clearer. She has toured the world, stood on important stages, telling men and women, boys and girls, that all are equal. buy tretinoin gel 0.1 The strike immediately shut down Drummond's exports since itincluded workers at its privately operated port as well aslaborers at its two mines, Pribbenow and El Descanso, located inthe north of the country. gat tribulus reviews Diplomats say the more than 16,000 peacekeepers are struggling with equipment problems, poor training of some contingents and the reluctance of some governments like Egypt to send their soldiers into dangerous areas. order singulair canada There's an edict in politics that those leaders who acquire power undemocratically tend to leave office undemocratically. Those who seize power in a military coup, for example, tend to depart not after a smooth and non-violent election, but by a revolution or another coup. methotrexate psoriatic arthritis how long Today, the Christie-McDonnell narrative has been revised in a way no one could have foreseen as recently as a year ago. Christie appears headed towards an easy re-election on Nov. 5, and he is among the best known Republicans expected to run for president in 2016. But McDonnell, who under Virginia law cannot succeed himself, will leave office in January stained by a scandal that threatens to derail his 22-year political career.

  Devbrat Tripathi

Hi,

i believe below is the correct answer.

SELECT SUBSTRING(fullname, 1, CHARINDEX(' ', fullname) - 1) AS Firstname,     
       SUBSTRING(fullname,
                 CHARINDEX(' ', fullname) + 1,
                 LEN(fullname) - CHARINDEX(' ', fullname)) AS Lastname
FROM yourTable                

  Rakesh Sharma       23 Sep 2018       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any