SDU Tools: Extracting initials from a name in SQL Server T-SQL
I recently came across a requirement to extract someone’s initials from within their name. That was a new one for me, so we added a new function into our free SDU Tools for developers and DBAs. It’s called InitialsFromName.
It’s a straightforward scalar function that takes two parameters:
@Name nvarchar(max) is the name to extract the initials from
@Separator nvarchar(max) is a separator placed between the returned initials. (Make it an empty string for none)
2020-05-06