Splitting contact names into component Title/Forename/Surname
Posted on 2006-07-04
Hi, just being lazy here!
Has anyone done a SQL stored procedure that will take a person's name and split it into its component parts?
Mr Frederick A Bloggs
Would split this into:
Initials: F A
Ideally be intelligent enough to also spot that Mr Bloggs should only populate the Title and Surname.
I have done something similar that uses the charindex and patindex functions, I just didn't want to have to reinvent the wheel if someone else has already done it!