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: )

380 reads

Blogs

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Default Credentials

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Default Credentials

Re-OPENing a Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Re-OPENing a Cursor

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers