how can i parse NameSurname field with t-sql ???

    NameSurname
---------------------------
John SMITH
Eric Smith PHILIPS

        Name                      Surname
-----------------------    ------------------------
John                           SMITH
Eric Smith                  PHILIPS

thanks

SharkSpeed wrote:
Here's an example:

CREATE TABLE Contacts (fullname VARCHAR(20) PRIMARY KEY)

INSERT INTO Contacts VALUES ('Bill Clinton')
INSERT INTO Contacts VALUES ('George W. Bush')
INSERT INTO Contacts VALUES ('Smith')

SELECT NULLIF(LEFT(fullname,LEN(fullname)+1 -
CHARINDEX(' ',REVERSE(' '+fullname))),'') AS firstname,
LTRIM(RIGHT(fullname,CHARINDEX(' ',REVERSE(' '+fullname)))) AS
lastname
FROM Contacts

Dynamic WHERE & Dates
with(updlock) - How many times on same table in single update?
Is there alternative to T-SQL USE <dbname> where <dbname> is varia
Using set theory in SQL Server 2005
COUNT of datediff