Remove and split data into multiple columns in select statement.
- by Muhammad Kashif Nadeem
I have data like following table
I want to remove Titles ( Mr. Miss, Dr etc) from name and want to split data into First name and last name if two names exists.
I want this in select statement. I can remove title using CASE statement but unable to split name into tow in same case statement.
I want data like this but in select statement, title removed and name splitted.