I have a name field, some have first name, middle initial, last name. Others are just first name, last name. I want to create a new field with the last name only. There's always a space before the last name.
Can someone tell me the statement I need to split this field?