Add a suffix or prefix to field

How would I add a suffix like a percentage % sign to the field results of a particular field coming back in my query?

I would think in a grid application, in values format, that I might be able to pick a column and say append this character onto the results for that field/column, but I don’t see anything like that…

Does anyone know how to do this?

I can do it in the sql query itself, but that is not really a best practice to follow…

thanks :slight_smile:

David

Re: Add a suffix or prefix to field

In the onRecord event of the grid:

{field_name} = {field_name}.’%’;

Regards,
Scott.

Re: Add a suffix or prefix to field

Thanks Scott. You are the guru.

Wow duh :slight_smile: thanks, I should of looked inside that event… makes sense.

I appreciate the solution/answer –

David