title: Remove and split data into multiple columns in select statement
body: <p>I have data like following table</p>
  
  <p><img src="https://i.stack.imgur.com/4x71h.png" alt="alt text"></p>
  
  <p>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.</p>
  
  <p>I want this in select statement. I can remove title using CASE statement but unable to split name into tow in same case statement.</p>
  
  <p>I want data like this but in select statement, title removed and name splitted.</p>
  
  <p><img src="https://i.stack.imgur.com/Qjwz2.png" alt="alt text"></p>