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

169 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

How to send queued emails

By dubem1-878067

After an upgrade,   sql server stopped sending emails.   Problem is not solved but during...

TLS 1.2 and Database mail

By miapjp

Hi, We use office 365, and just recently received an email from them saying...

Left join not pulling all from left table

By jeffshelix

T has 57,000 distinct rows Z has over a million.  I did row over...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers