Group, I am building my first Crystal Report and I have 3 fields (City, State, Zip) and they are inline.  I would like to trim each field so they exclude additional spaces depending on the length of the field and also separate them by a comma.  Currently the length of the field is determined by the textbox length so for example you have Tulsa          ,  AZ       , 00000       Instead of Tulsa, AZ, 00000

Anyway to set a field to rtrim?

Any help is greatly appreciated.

Assuming that your back-end database is SQL Server, write a function that takes three arguments and returns a varchar.

You can LTRIM(RTRIM(field)) for each field and combine as in:

RETURN LTRIM(RTRIM(City)) + ', ' + LTRIM(RTRIM(State)) + ', ' + LTRIM(RTRIM(Zip))