I'm struggling with SQL commands SUBSTRING and CHARINDEX to extract the initials of each name in the one field below
Cornelia Maria Margaretha
Alison McMillan Julia Frances
Adrienne Alice Fowler Lorraine Joy
Joy Catherine Gertrude Maria Wihelmina Toni
What I need is the first letter of each name for addressing purposes.
All help is much appreciated.