Get Last Name, First name and Middle Name from Full Name

Question

Get Last Name, First name and Middle Name from Full Name

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

n.heyen SSCrazy Points: 2849 More actions · Answer 1

I guess I never came back to let everyone know that the suggestions worked great! Using a temp table to add the columns gave us what we needed.

I'm trying to understand how it actually works with STUFF and CHARINDEX and REPLACE and all that. But it is excellent!

All I have to do is get this in DTS so it can be automated... Expect questions about this too.:-D

Thanks to all!

Norman

csnetsurfer SSC Enthusiast Points: 101 More actions · Answer 2

Garadin - Tuesday, December 8, 2009 3:35 PM

Here's how to drop the temp table. Just trying to help out!

IF OBJECT_ID('tempdb..#names') IS NOT NULL
DROP TABLE #names
GO

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 3

Please note: 8 year old thread

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass