humour

Technical Article

RE: Parsing the name field with T-SQL

  • Reply

Raw DataCol001AABY TAMARA J AADNESEN MARJORIE AARANT MAUREEN R AARON MICHELLEE AARON PATRICIA J ABBA DAVID W ABBATE ANTHONY PSELECT SUBSTRING(Col001,1,CHARINDEX(' ',Col001)) AS LName, SUBSTRING(Col001,CHARINDEX(' ',Col001)+1, CHARINDEX(' ',Col001,CHARINDEX(' ',Col001)+1)-CHARINDEX(' ',Col001)+20) AS FName, REVERSE(SUBSTRING(REVERSE(Col001),1,CHARINDEX('',REVERSE(Col001)))) AS MName FROM tableGives me this:LName       FName           MNameAABY         TAMARA J  AADNESEN  MARJORIE  AARANT      MAUREEN R  AARON        MICHELLEE  AARON        […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-12-29

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers