1. how to capture the last character of a string using functions

[mujahid1303]

1. how to capture the last character of a string using functions 

2. how to capture the middle word of the string 

[art297]

Provide a couple of examples and the results you'd want from those examples. Make sure to include at least one example that has an even number of words.

Art, CEO, AnalystFinder.com

[LinusH]

1) SUBSTR() using -1 for position.
2) Middle is not always clear, whatbif there's a even no of words? Besides that, you could use a combination of COUNTW and SCAN functions.