Parse and Update 1

[dvannoy]

I have a field called name. I'm trying to take both the first and last name from the full name field and put them into seperate field called firstname and lastname.

UPDATE TEST

SET LASTNAME = PARSENAME(REPLACE(NAME, ', ',), 2),
SET FIRSTNAME = PARSENAME)REPLACE(NAME, ', ',),1)

getting error message 'incorrect syntax near ')'

any help would be appreciated

 

[gmmastros]

UPDATE TEST
SET    LASTNAME  = PARSENAME(REPLACE(NAME, ', ','.'),2),
       FIRSTNAME = PARSENAME(REPLACE(NAME, ', ','.'),1)

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dvannoy]

Okay,

Now I'm getting 'Incorrect syntax near the keyword set'

 

[dvannoy]

nevermind.....got it...

thanks