Change initial character to lower case

[Dennis A.]

In a query expression, how do I change only the initial character in a text
field to lower case? Thanks, group.

 

[Barry Gilbert]

If your source field is called MyText, your expression would be:
CorrectedTex: LCase(Left$(MyText,1)) & Right$(MyText,Len(MyText)-1)

HTH,
Barry

 

[Jerry Whittle]

LC1: LCase(Left([FieldName],1)) & Mid([FieldName],2)