take the first two letters from the field

[maas]

Hello All,

I am having a field called description. The request is to show only the first two letters and ignore the others. It is kind oftrim o concat.


So, how can I do that?

Thanks

 

[Madawc]

left({your.field}, 2)

That's assuming no leading spaces or other complications.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[maas]

Thank you, I will try