How to format cell / data apprearecnce under a table

Hello All,

I uploaded custtable under the database, the data looks fine except that the name that apprears has a lot of distance e.g

it should be :

firstname lastname however the format appears very strange:

firstname lastname

firstname lastname

fistname lastname

Same is the case with the address, I need to adjust or format the apperance that appears on the cell. Is there a way/ sql statement to format the data under the table so that the apprearence looks okay.

I will really appreciate any sort of help on this one.

Thanks,

Rashi

Check the positioning properties of the grid/cell.

You could try trimming leading 'space' characters in the SELECT query, e.g., ltrim( FirstName ), ltrim( LastName ).