truncate an alpha field

[sjanssen]

I am trying to change a middle name field, so that instead of returning the full middle name, it only returns the first initial. It appears that the "truncate" function only works for numerical data. Does anyone know what function to use for alpha field?

 

[fisheromacse]

to get just the left-most character:

left({table.field},1)

 

[lbass]

Or you could use:

{table.field}[1]

-LB