I want to parse out FIRST, MIDDLE, and LAST names using TSQL.
The problem I have is that data names are separated by space only.
select SUBSTRING(TBANAME, 1, CHARINDEX(' ', TBANAME) - 1) AS [Last_Name] from MYTABLE .... but not sure how to get the rest....
Here is sample of data field name [TBANAME]:
ARROYO JOEL E
ENGLANOFF JOSEPH SHIMON
CRAWFORD SHANNON DAVID
FASSIHI AMIR ALI
CASTILLO FRANCISCO ALVIN
GUIRGUIS SYLVIA MARY E
HATTI VIKRAM MYSORE
KAM CHRISTINE NORRED