Dynamically filling up fields of a node in Drupal We have a content type named "Person", which has fields as Full Name, Age, Address etc.

There are thousands of people entries on the site. We are using Views to sort out people's list on different pages as per need.

Lately, there has been a requirement that we need to sort the list of people by Last Name. But the problem is that there's no last name field as there's only "Full Name" field of the person in the site. 

I am using views to sort the results in the pages and I am not sure how to sort the results by last name. Is there any way I can achieve this?

May be I can create a field as "Last Name" in the content field but is there a way I can dynamically fill in the Last Name by extracting Last word from Full Name?

May be through someway in SQL?

Any idea or assistance would be highly appreciated.

Thanks.
Here is my way of doing it:


Create a Computed Field to manipulate the substring (Last Name) and store it as a field



  Computed Field is a very powerful field module that lets you add a
  custom "computed fields" to your content types. These computed fields
  are populated with values that you define via PHP code.



Use Computed Field Tools to bulk update the value for the existing nodes



  The Computed Field module only updates its computed values on saves or
  on load (if no computed value is computed yet). This is not optimal
  when using computed values in lists etc., or if you should wish to
  change the logic in the computed field.



Use this Computed Field as a sort criteria in Views.