I have one field that has the first and last name separated by a space. I
would like to split the field into two fields one for the first name and one
for the last name. The names are all different lengths. I am unable to find
any command to do this. Like the reverse of concatenate.