How to get the second character on a word

Hi all!

How to get the second character on a word, for Example:

Original Word: Gerard
I need to extract the second character on this word “E”

If I use Left I get X number of characters from left, and If i use Right I get characters from right side.

Regards

mid()

Look at Mid.

i.e. result = mid(“Gerard”, 2, 1) 'starting at character 2, for the next 1 character

Thanks