How to return a single character from a name field

[zogpound]

I need a query that will return only the first character in a text field. I have done this before but can't seem to get it to work. The field name is "First Name". I have tried the following expression from the expression builder "Left (First Name, 1)" But this does not return the result I'm looking for.
Any advice is greatly appreciated.

Eric

 

[CJBIRKIN]

Hello

try putting this in a blank column in the query
nameleftchar: Left([First Name],1)

Chris

 

[zogpound]

That worked great. Thanks Chris.

 

[CJBIRKIN]

no worries