You can use the following formula:
substring( Name, ( charindex( ‘ ‘, Name ) + 1 ), 50 )
This will find the position of the space character and add one to it to get the first letter of the second word. The parameter, 50, can be increased if any of your surnames are longer than 50 characters.
Discuss This Question: 7  Replies