Against an Excel table using JET SQL I think the MID function should
work:
"Select mid(field_name,1,1) as CharacterOne from table_name" would pull
the first character.

In other flavors of SQL the SUBSTR function would do the same thing:
Select SUBSTR((field_name,1,1) as CharacterOne from table_name