Get full name of a person

Person name may have these combination in database1. firstname only2. middlename only3. lastname only4. firstname + middlename5. firstname + lastname6. middlename + lastnameAnd firstname, middlename, lastname may contain null or empty string in data. but usee want to display Fullname without spaces then how will combine all.

1 (1)

2007-06-28 (first published: )

184 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

By Ginger Keys Daniel

Comments posted to this topic are about the item Move Data from SQL Server...

Knowing What You Don’t Know

By Grant Fritchey

Comments posted to this topic are about the item Knowing What You Don’t Know

Automate Import of LIBOR Rates

By Phil Parkin

Does anyone have any recommendations for sites which publish the daily LIBOR rates in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers